Thread: Macro To consolidate All Open Workbooks Into One Workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
  
Posts: 221
Default 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.


Reply With QuoteReply With Quote