I'll try my best to describe this one.

Cells B75 to D76 feed to a multiple of worksheets.

There are 6 different style types below this area that need to be
moved to the area above, so the information links to the multiple of
sheets for printing.

The problem is that I want to automate this. For instance in Row 78
and 79 I have Style S with all the pertinent data. Style S has 24
different sizes. S-A, S-B to S-X. I need to copy B78 - D79 to B75 -
D76 and then run the macro. I then need to copy B80 - D82 to B75 -
D76 and run the macro and continue until all of Style S is finished.

We have 6 different styles, with anywhere from 3 to 39 sizes.

The easiest way that I could think of was to copy all of the certain
Style information to rows 74 & 75 and run the macro and then delete
B75-D76 and then run until the Style was complete.

TIA
Gerry