| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying Several Workbooks into one Workbook as Worksheets
I have several Workbooks in a folder. Each Workbook has only one Worksheet.
How can I copy all the Workbooks into one Workbook with as many worksheets as there were Workbooks in the folder? Thanks. |
|
#2
|
|||
|
|||
|
Try this example
http://www.rondebruin.nl/copy3.htm See this example http://www.rondebruin.nl/copy3.htm#sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Blue_Crystal" wrote in message ... I have several Workbooks in a folder. Each Workbook has only one Worksheet. How can I copy all the Workbooks into one Workbook with as many worksheets as there were Workbooks in the folder? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
| Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
| Linking Workbooks | Excel Worksheet Functions | |||
| Copying worksheet from workbook to another | Excel Worksheet Functions | |||
Linear Mode
