Macro To consolidate All Open Workbooks Into One Workbook
 

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.

Macro To consolidate All Open Workbooks Into One Workbook
 

Try this:
http://vbaexpress.com/kb/getarticle.php?kb_id=773

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"carl" wrote in message
...
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.

Macro To consolidate All Open Workbooks Into One Workbook
 

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

"Anne Troy" wrote:

Try this:
http://vbaexpress.com/kb/getarticle.php?kb_id=773

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"carl" wrote in message
...
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.

Macro To consolidate All Open Workbooks Into One Workbook
 

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
****************************
"carl" wrote in message
...
Thank you for your help. This code looks like it is designed for workbooks
that are not open ?

"Anne Troy" wrote:

Try this:
http://vbaexpress.com/kb/getarticle.php?kb_id=773

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"carl" wrote in message
...
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.