software

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.quot;Word problemsquot; wrote:

gt; Greetings all,
gt;
gt; I have about 30 Excel files that all contain the exact same columns but
gt; different data. Is there a way to merge all 30 files into one “master” Excel
gt; file?
gt;
gt; Thanks in advance for your help.
gt;

Try this
www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;Word problemsquot; gt; wrote in message ...
gt; Greetings all,
gt;
gt; I have about 30 Excel files that all contain the exact same columns but
gt; different data. Is there a way to merge all 30 files into one quot;masterquot; Excel
gt; file?
gt;
gt; Thanks in advance for your help.
gt;
Tom,
Thanks for your help. Since posting my message I have found this quot;add-inquot;,
though a bit funky it did what I needed it to do.

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

Thanks again for your help.

quot;TomHinklequot; wrote:

gt; cut and paste, cut and paste.
gt; you CAN make a macro to do it, but I'll offer an alternative suggestion.....
gt;
gt; For data storage, access is truly the right tool, but we'll stick with excel
gt; for now.
gt;
gt; I'm assuming that each different workbook or sheet has a different function.
gt; Add ONE column to each sheet and put in that column the name of the
gt; workbook/worksheet/whatever.
gt;
gt; Then combine all your data.
gt;
gt; Going forward, keep all of the data together. Use Autofilter to split it
gt; out if you need to..
gt;
gt; I could go into more depth, BUT it is much easier to pull data out for
gt; reporting, than it is to combine it if it's all stored seperately.
gt;
gt; Just a matter of approach.
gt;
gt;
gt;
gt;
gt;
gt; quot;Word problemsquot; wrote:
gt;
gt; gt; Greetings all,
gt; gt;
gt; gt; I have about 30 Excel files that all contain the exact same columns but
gt; gt; different data. Is there a way to merge all 30 files into one “master” Excel
gt; gt; file?
gt; gt;
gt; gt; Thanks in advance for your help.
gt; gt;

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.quot;Ron de Bruinquot; wrote:

gt; Try this
gt; www.rondebruin.nl/copy3.htm
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Word problemsquot; gt; wrote in message ...
gt; gt; Greetings all,
gt; gt;
gt; gt; I have about 30 Excel files that all contain the exact same columns but
gt; gt; different data. Is there a way to merge all 30 files into one quot;masterquot; Excel
gt; gt; file?
gt; gt;
gt; gt; Thanks in advance for your help.
gt; gt;
gt;
gt;
gt;