| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Workbooks
I have multiple workbooks each of which contains a great deal of data that is
summarized on a single sheet within each workbook. I am trying to consolidate each of these "summary" sheets into a single seperate workbook. I have structured the workbooks into directories within windows and would like to build a macro that will be able to open every workbook in the directory (one at a time) and copy the sheet I need into my new workbook . Any thoughts? Oh yeah each workbook has a different name and each directory has a different number of workbooks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Workbooks
Hi Kelly
Start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly" wrote in message ... I have multiple workbooks each of which contains a great deal of data that is summarized on a single sheet within each workbook. I am trying to consolidate each of these "summary" sheets into a single seperate workbook. I have structured the workbooks into directories within windows and would like to build a macro that will be able to open every workbook in the directory (one at a time) and copy the sheet I need into my new workbook . Any thoughts? Oh yeah each workbook has a different name and each directory has a different number of workbooks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move multiple tabs in multiple workbooks to a master? | Excel Worksheet Functions | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
