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?

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?

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?