Macro To consolidate All Open Workbooks Into One Workbook

C

carl

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.
 
C

carl

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
****************************
 
Top