Hello, I have a list of items currently in my inventory and a separate list indicating when I will receive shipments (open purchase orders) of additional items.
I want to extrapolate the date and quantity data from the open purchase orders sheet to understand how inventory levels will adjust going forward. Crude example below.
I want to extrapolate the date and quantity data from the open purchase orders sheet to understand how inventory levels will adjust going forward. Crude example below.
Book2 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Item | Current Qty | 1/15/2021 | 2/15/2021 | 2/20/2021 | 3/7/2021 | 2/5/2021 | 4/1/2021 | 5/23/2021 | ||
2 | Apple | -10 | 4 | 4 | 10 | ||||||
3 | Pear | -2 | 4 | ||||||||
4 | Orange | 0 | 19 | ||||||||
5 | Banana | -25 | 18 | 20 | |||||||
6 | |||||||||||
7 | Item | Qty | Date | ||||||||
8 | Grape | 3 | 1/1/2021 | ||||||||
9 | Apple | 4 | 1/15/2021 | ||||||||
10 | Mango | 1 | 2/3/2021 | ||||||||
11 | Orange | 19 | 2/5/2021 | ||||||||
12 | Avocado | 2 | 3/6/2021 | ||||||||
13 | Pear | 4 | 3/7/2021 | ||||||||
14 | Banana | 18 | 4/1/2021 | ||||||||
15 | Apple | 4 | 2/15/2021 | ||||||||
16 | Apple | 10 | 2/20/2021 | ||||||||
17 | Banana | 20 | 5/23/2021 | ||||||||
Sheet1 |