I have been racking my brain to figure out the best way to do this but i just can't figure it out using formulas i have never really tried to write a VBA code
So what i am trying to do is to supply our sales team with dates of when we think a manufacturing jobs will be finished. There are multiple part numbers to be manufactured and there could many jobs for the same part with different dates due to the availability of components and i currently fill this information manually
Below is a sample part number with the quantity ordered, back ordered qty and the date i would fill in. Each line is a separate order
What i would like is for sales order sheet to bring back the estimated finished date of the production based on the qty. The first 33 back ordered sales will show the first production order/date, the next batch of sales orders will show the date for the production of the 20 units
So what i am trying to do is to supply our sales team with dates of when we think a manufacturing jobs will be finished. There are multiple part numbers to be manufactured and there could many jobs for the same part with different dates due to the availability of components and i currently fill this information manually
Below is a sample part number with the quantity ordered, back ordered qty and the date i would fill in. Each line is a separate order
What i would like is for sales order sheet to bring back the estimated finished date of the production based on the qty. The first 33 back ordered sales will show the first production order/date, the next batch of sales orders will show the date for the production of the 20 units
