want to copy many workbooks into 1 workbook

  • Thread starter Thread starter april
  • Start date Start date
A

april

i have a folder with over 400 workbooks (1 worksheet per workbook). i want
to copy these workbooks into a single workbook with 400 tabs. is there a
fast way to do this? say a macro?

thanks in advance
 

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

Merge Multiple workbook sheets into one workbook 0
Macro to push data to another workbook 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sharing workbooks limitations - Merged Cells 12
Copy same formula to all worksheets in a workbook 1
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
summarizing data from various workbooks 3
linking many workbooks 6

Back
Top