Merging to identical Excel files

W

Word problems

Greetings all,

I have about 30 Excel files that all contain the exact same columns but
different data. Is there a way to merge all 30 files into one “master†Excel
file?

Thanks in advance for your help.
 
T

TomHinkle

cut and paste, cut and paste.
you CAN make a macro to do it, but I'll offer an alternative suggestion.....

For data storage, access is truly the right tool, but we'll stick with excel
for now.

I'm assuming that each different workbook or sheet has a different function.
Add ONE column to each sheet and put in that column the name of the
workbook/worksheet/whatever.

Then combine all your data.

Going forward, keep all of the data together. Use Autofilter to split it
out if you need to..

I could go into more depth, BUT it is much easier to pull data out for
reporting, than it is to combine it if it's all stored seperately.

Just a matter of approach.
 
W

Word problems

Thanks Ron. I will give your solutions a try. It looks a little complex to
setup but I think it will be cheaper in the long run.
 
Top