How can I append multiple sheets from mulitple xls. files. into 1

  • Thread starter Thread starter salem_gladiator
  • Start date Start date
S

salem_gladiator

I have multiple xls. files that have multiple sheets. I want to consolidate
into one file with a number of sheets. How do I do that? Can it be done
without buying a add in?
 
You can do it with a macro or a lot of manual work. However, you may not
want to make the file TOO big especially if you have memory constraints.
More info?
 

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

Multiple workbooks to one worksheet 3
Formula within filename link 2
Is it possible to load sheet without update links? 2
How do I get totals from several different worksheets on to one? 1
How do I open multiple files with names and locations that change each month? 0
How to create .pdf dummy files from .xls using batch file 1
Is it possible to save .XLA sheet as new .XLS file 2
changing the address of data in a cell 3

Back
Top