Production schedule dates

Bureido

New Member
Joined
Jan 10, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Sales order.JPG
    Sales order.JPG
    133.5 KB · Views: 22
  • Sales order.JPG
    Sales order.JPG
    119.6 KB · Views: 23

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top