| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy multiple selctions to different pages
My code does exactly what you say. The value of 1 +
Sheets("Sheet1").Cells(r3, "BU") will vary depending on what is in column BU. If it = 1, Sheet2 will be used. If it = 2, Sheet3 will be used, etc. If you want to copy from multiple rows, then put my code within a loop. Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cells from multiple pages to one sheet w/ if statement | Excel Worksheet Functions | |||
| Copy Excel to Word - Multiple Pages | New Users to Excel | |||
| Adapting Excel 4 Macro Page Setup for multiple pages | Excel Programming | |||
| Error using a macro to print multiple pages. | Excel Discussion (Misc queries) | |||
| How do I allow multiple drop down list selctions in one cell | New Users to Excel | |||
Threaded Mode
