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

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?
 
D

Don Guillett

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?
 
Top