Merging multiple workbooks
I have about 30 different workbooks that we update monthly for financial
closing. We want to create one workbook that combines certain sheets from each of those 30 books, change their tab names and send to the executive team for monthly reporting. We have figured out that we can run a macro to do that but it keeps getting hung up at the prompts for updating linked workbooks and like named tabs. Any suggestions? |
Merging multiple workbooks
The first suggestion would be to post the code your macro is using and
indicate where it's stopping. Dave -- Brevity is the soul of wit. "Stacey" wrote: I have about 30 different workbooks that we update monthly for financial closing. We want to create one workbook that combines certain sheets from each of those 30 books, change their tab names and send to the executive team for monthly reporting. We have figured out that we can run a macro to do that but it keeps getting hung up at the prompts for updating linked workbooks and like named tabs. Any suggestions? |
Merging multiple workbooks
Start here Stacey
http://www.rondebruin.nl/copy3.htm Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Stacey" wrote in message ... I have about 30 different workbooks that we update monthly for financial closing. We want to create one workbook that combines certain sheets from each of those 30 books, change their tab names and send to the executive team for monthly reporting. We have figured out that we can run a macro to do that but it keeps getting hung up at the prompts for updating linked workbooks and like named tabs. Any suggestions? |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com