copy and paste 3 rows run macro and continue to end of columns

[Wally]

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

 

[Don Guillett Excel MVP]

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

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."