Hello All,
I'm new to the forum and I am looking for a solution to this problem.
This spread sheet has the purpose of Scheduling a Production of a certain material.
In the first Sheet (P.O. Register) of the document there is a List with a number of Purchase Orders (P.O.s) and all it's information entered by hand, besides a calculation on how many days of Production Lead Time i need to produce that certain material.
On the second Sheet (Production Scheduler) there are all days of a certain month (in this case March), and all days are subdevided in 4 parts (1/4 or 0,25).
Every line of a day represents 0,25 of that whole day.
For exemple i have a P.O. with a production Lead Time of 3,50 days.
That P.O. will repeat for 14 lines, until the production Lead Time reaches 0< days.
After the Lead Time for that P.O. reaches zero or below, the next P.O. on the line will enter the Production Scheduler Sheet until it reaches 0< and so on.
What i need to "automate" is for the "P.O." Row ('P.O. Register'!$C$8:$C$1000) to keep reapeating itself untill the "Production Lead Time" Row ('Production Scheduler'!$L$4:$L$1000) reaches 0< days.
After the P.O. for reaches 0< days Production Lead Time, jump to the next Line with a new P.O. and repeat the process until it reaches 0< Production Lead Time and so on.
I'm not sure i could express clearly, but i hope you all understand.
I'm also not sure how easy or complicated this problem is, so i would like some sugestions or thoughts on this.
Attached follows and exemple of the Spred Sheet i just mentioned the examples above.
In the "Production Scheduler" Sheet, all values where entered by hand, but what i need is to make it automated after i register a new P.O. on the "P.O. Register" sheet.
Thank you all very much.
I'm new to the forum and I am looking for a solution to this problem.
This spread sheet has the purpose of Scheduling a Production of a certain material.
In the first Sheet (P.O. Register) of the document there is a List with a number of Purchase Orders (P.O.s) and all it's information entered by hand, besides a calculation on how many days of Production Lead Time i need to produce that certain material.
On the second Sheet (Production Scheduler) there are all days of a certain month (in this case March), and all days are subdevided in 4 parts (1/4 or 0,25).
Every line of a day represents 0,25 of that whole day.
For exemple i have a P.O. with a production Lead Time of 3,50 days.
That P.O. will repeat for 14 lines, until the production Lead Time reaches 0< days.
After the Lead Time for that P.O. reaches zero or below, the next P.O. on the line will enter the Production Scheduler Sheet until it reaches 0< and so on.
What i need to "automate" is for the "P.O." Row ('P.O. Register'!$C$8:$C$1000) to keep reapeating itself untill the "Production Lead Time" Row ('Production Scheduler'!$L$4:$L$1000) reaches 0< days.
After the P.O. for reaches 0< days Production Lead Time, jump to the next Line with a new P.O. and repeat the process until it reaches 0< Production Lead Time and so on.
I'm not sure i could express clearly, but i hope you all understand.
I'm also not sure how easy or complicated this problem is, so i would like some sugestions or thoughts on this.
Attached follows and exemple of the Spred Sheet i just mentioned the examples above.
In the "Production Scheduler" Sheet, all values where entered by hand, but what i need is to make it automated after i register a new P.O. on the "P.O. Register" sheet.
Thank you all very much.