Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste 3 rows run macro and continue to end of columns
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste 3 rows run macro and continue to end of columns
On Oct 25, 11:01*am, Wally wrote:
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste with Hidden Rows/Columns Excel 2007 | Excel Discussion (Misc queries) | |||
Copy & Paste converting rows to columns | Excel Discussion (Misc queries) | |||
Macro-continue to paste last column | Excel Discussion (Misc queries) | |||
copy columns paste in rows | Excel Programming | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |