# Repeat Row until Condition is met, Them move to Next Row and Reapeat

#### ogroww

##### New Member
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.

#### Attachments

• 18.5 KB Views: 11

#### Anbuselvam K

##### Member
I assume that Day Partial start time and end time are fixed.
I split the start and end time

Download the file and select the client name then press [ Fill The "N" ]

It will fill the "N" Column until Zero.

Let me know the results are correct by checking with many clients

Select one client only (Not multi-selection)

#### Attachments

• 32.7 KB Views: 0

#### Anbuselvam K

##### Member
Check the attached file which is filling all.

#### Attachments

• 31.3 KB Views: 5

#### ogroww

##### New Member
I assume that Day Partial start time and end time are fixed.
I split the start and end time

Download the file and select the client name then press [ Fill The "N" ]

It will fill the "N" Column until Zero.

Let me know the results are correct by checking with many clients

Select one client only (Not multi-selection)

View attachment 66173
Thank you very much for the help.
This works

You are Welcome!