Consolidating spreadsheets
Does anyone have an easy code to consolidate all workbooks within a
specified folder? Create new workbook Get contents of workbook1 Paste into new workbook Get contents of workbook2 Paste under contents of workbook 1 in new workbook Get contents of workbook3.... Until there are no more workbooks in that folder. |
Consolidating spreadsheets
Hi Jess
See this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jess" wrote in message oups.com... Does anyone have an easy code to consolidate all workbooks within a specified folder? Create new workbook Get contents of workbook1 Paste into new workbook Get contents of workbook2 Paste under contents of workbook 1 in new workbook Get contents of workbook3.... Until there are no more workbooks in that folder. |
Consolidating spreadsheets
Thanks!!!
Ron de Bruin wrote: Hi Jess See this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jess" wrote in message oups.com... Does anyone have an easy code to consolidate all workbooks within a specified folder? Create new workbook Get contents of workbook1 Paste into new workbook Get contents of workbook2 Paste under contents of workbook 1 in new workbook Get contents of workbook3.... Until there are no more workbooks in that folder. |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com