Please forgive my novice approach to this problem, I am a newbie to macros.
I've done simple ones but this one I am scratching my head too much.

This is the data I work with:
Code Product Line Batches Start Finish Day

Code 1 Product 1 Line 1 4 7:00 11:00 Monday
Changeover 11:00 11:30
Monday
Code 2 Prodcut 2 Line 2 24 11:30 22:45 Tuesday
Changeover 4:15 4:45
Tuesday
Code 3 Product ..... and so on

Code is keyed in (it's a number).
-The cell for product contains a lookup formula to get the description.
-Line is keyed in (Alphanumeric).
-Batches is a number, 95% of the time is a multiple of three.
-Start Time for Product 1 is 07:00AM, for the next product however, it will
be -Finish Time of the Changeover.
-Finish Time is calculated based on the time it takes to run 3 batches, 2 or
1.
-Day - Can be inputted after the macro generates the schedule

An example of a detail schedule would look like this:

Code Product Line Batches Start Finish Day

Code 1 Product 1 Line 1 3 7:00 10:00 Monday
Code 1 Product 1 Line 1 1 10:00 11:00 Monday
Changeover 11:00 11:30
Monday
Code 2 Prodcut 2 Line 2 3 11:30 01:30 Tuesday
Code 2 Prodcut 2 Line 2 3 01:30 03:30 Tuesday

All the way until 24 batches are displayed.

I hope someone will be able to help.