32 formatted workbooks into 1 new workbook with 32 worksheets

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi,
i am in trouble! Can a very knowledgeable person explain me the steps
to resolve this problem please?
i have 32 formatted individual workbooks, each containing a single
worksheet.
i need to create a single workbook containing all 32 workbooks as
worksheets.
Is that possible without having to copy and paste the whole thing?
Thank you for taking time to answer this question.
Alain
 
Ron,
i used one formula (Copy a sheet from each workbook into your
workbook) from your website and it worked like brillantly.
you just simply made my day. thank you so much.
Alain
 
You must log in or register to reply here.

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

Copy a worksheet to a new workbook 6
How to transfer a worksheet into a new workbook and keep the formulas intact 5
copying a style from one worksheet to another in the same workbook 1
You may not use references to other worksheets or workbooks forConditional Formatting criteria. 5
Excel 2003 - VBA - Closing workbooks without error 4
Merging multiple workbooks into one master workbook 2
Copy/Paste from one workbook to another not recognized by formulas 2
Pulling data from multiple workbooks 2

Back
Top