A guru site should be the right place to ask.
What the ultimate goal for this sheet is to be able to put the dates from the next available purchase orders that will cover the amount required by customer, based on amount coming in, and when.
The dynamic values that can change are the following :
Date the stock purchase order is due (A11-A15)
The amount that is coming in on that purchase order (E11-E15)
The quantity ordered from the supplier (E3-E6) or remaining (diff between Qty and Rec)
I was hoping to fill the dates (J3-J6) based on the numbers in the (Remain) H column, and once the number was greater than the sales order, would use the corresponding purchase order date. Doesn't have to be pretty, just affective.
Hope that all made sense.
View attachment sample.xls
What the ultimate goal for this sheet is to be able to put the dates from the next available purchase orders that will cover the amount required by customer, based on amount coming in, and when.
The dynamic values that can change are the following :
Date the stock purchase order is due (A11-A15)
The amount that is coming in on that purchase order (E11-E15)
The quantity ordered from the supplier (E3-E6) or remaining (diff between Qty and Rec)
I was hoping to fill the dates (J3-J6) based on the numbers in the (Remain) H column, and once the number was greater than the sales order, would use the corresponding purchase order date. Doesn't have to be pretty, just affective.
Hope that all made sense.
View attachment sample.xls