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. |
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. |
All times are GMT +1. The time now is 07:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com