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