Forum Discussion
Excel
I want to sum x amount of months (no more than 12) usually 4- months at a time, subtract another cell of inventory levels, then use the current date to return a date of how long the inventory will la...
HansVogelaar
I thought about this way of presenting the issue
Looking at open sales orders:
If I have a column that is labeled inventory part number "A" (Example: But can range from row 1 to 30 or 1-5000)
If I have a column that is labeled quantity per purchase order "B" (Example: But can range from row 1 to 30 or 1-5000)
If I have a column that is labeled requested date "C" (Example: But can range from row 1 to 30 or 1-5000)
Then I have a cell of inventory levels "D" and "E" (One cell for each level)
(An assembly and Subassembly)
Can I have Excel look at the Part number "A", Talley up the QTY "B", and then subtract "-" stock inventory levels "D+E", while looking at the requested date and have Excel tell me by 8/16/2022 You will be "X-amount" short for that order?
I thought about this way of presenting the issue
Looking at open sales orders:
If I have a column that is labeled inventory part number "A" (Example: But can range from row 1 to 30 or 1-5000)
If I have a column that is labeled quantity per purchase order "B" (Example: But can range from row 1 to 30 or 1-5000)
If I have a column that is labeled requested date "C" (Example: But can range from row 1 to 30 or 1-5000)
Then I have a cell of inventory levels "D" and "E" (One cell for each level)
(An assembly and Subassembly)
Can I have Excel look at the Part number "A", Talley up the QTY "B", and then subtract "-" stock inventory levels "D+E", while looking at the requested date and have Excel tell me by 8/16/2022 You will be "X-amount" short for that order?