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.

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.





"Word problems" wrote:

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.

Try this
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Word problems" wrote in message ...
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.

Tom,
Thanks for your help. Since posting my message I have found this "add-in",
though a bit funky it did what I needed it to do.

http://www.digdb.com/excel_add_ins/c..._sheets_files/

Thanks again for your help.

"TomHinkle" wrote:

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.





"Word problems" wrote:

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.

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.


"Ron de Bruin" wrote:

Try this
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Word problems" wrote in message ...
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.