Macro To consolidate All Open Workbooks Into One Workbook

G

Guest

I have 10 open workbooks that each contain 30 worksheets.

Is there a way to have these 300 worksheets consolidated into one workbook ?

Thank you in advance.

Regards.
 
G

Guest

Thank you for your help. This code looks like it is designed for workbooks
that are not open ?
 
A

Anne Troy

I would go to the Excel VBA newsgroup, post the code, and ask how it shold
be altered for open workbooks.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidate Multiple Workbooks - Excel 2007 1
Macro For Consolidating WorkBooks 1
Help on consolidate worksheets from different workbooks into one 2
Copying Worksheets From Different Workbooks using Marco 4
can you group multiple worksheets into a sub menu 1
Excel 2007 - Linking workbooks 1
Consolidate different sheets to different workbooks 3
consolidate and compare workbooks in excel 1

Top