| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple workbooks to sheets
I have 30 workbooks with one sheet each. All sheets are identical in
structure, only the data varies. What code will copy the sheet in each workbook to a new sheet in a consolidated workbook. Note this is not a merge. I need 30 sheets in the consolidated workbook. Best regards, -- Drew Yallop |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks to sheets
See this page Drew
http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "thomasDrew" wrote in message ... I have 30 workbooks with one sheet each. All sheets are identical in structure, only the data varies. What code will copy the sheet in each workbook to a new sheet in a consolidated workbook. Note this is not a merge. I need 30 sheets in the consolidated workbook. Best regards, -- Drew Yallop |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks to sheets
Thank you Ron. Works great. Nice code.
Best regards, Drew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy multiple sheets to seperate workbooks | Excel Discussion (Misc queries) | |||
| creating multiple sheets, then individualized workbooks for each sheet | Excel Discussion (Misc queries) | |||
| HELP TO COMBINE MULTIPLE SHEETS IN MULTIPLE WORKBOOKS | Excel Programming | |||
| combo box multiple workbooks / sheets | Excel Programming | |||
| Activating sheets with same name in multiple workbooks | Excel Programming | |||
Linear Mode
