Your question doesn't provide all the information necessary to do what you
want.

1) How do you know how many batches of a product are to be run? I'm
thinking that you have 3 lots that are run together, but it's not clear from
the posting.
2) How long is a run for each product?
3) Why do you need to split information every three runs? (3 lots per run?)

Thanks,
Barb Reinhardt



"Mike" wrote:

Hello all,

I have the following data and would like to expand it:
Product Description Line Batches Start Finish

A AAA L1 7 7:00

I like the macro to blow this information into the following schedule:

A AAA L1 3 7:00 8:30
A AAA L1 3 8:00 10:30
A AAA L1 1 10:00 12:00
Changeover 12:00 12:20
B BBB L1 3 12:20 14:20

AND SO ON .....

The macro needs to be smart enough to split the number of batches into 3's
and copy the formulas down, inserts a changeover after each product and go
grab the next product until the last product on the schedule.

Any help would be greatly apprecited.

Mike