software

Hi,

I have hundreds of excel files under 1 folder with exactly same # of columns
and same column names in each file, e.g. file1.xls, file2.xls, file3.xls,
..... file100.xls.

Just wonder if there is a way in Excel (2003) to merge or concatenate all
these similar files into 1 new-big excel file so I can do analysis over this
1 file instead of 100 files???

Thanks in advance!!!

John Lin

Start here John
www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;Johnquot; gt; wrote in message ...
gt; Hi,
gt;
gt; I have hundreds of excel files under 1 folder with exactly same # of columns
gt; and same column names in each file, e.g. file1.xls, file2.xls, file3.xls,
gt; .... file100.xls.
gt;
gt; Just wonder if there is a way in Excel (2003) to merge or concatenate all
gt; these similar files into 1 new-big excel file so I can do analysis over this
gt; 1 file instead of 100 files???
gt;
gt; Thanks in advance!!!
gt;
gt; John Lin
Look also at the templates
www.rondebruin.nl/mail/templates.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;Johnquot; gt; wrote in message ...
gt; Hi,
gt;
gt; I have hundreds of excel files under 1 folder with exactly same # of columns
gt; and same column names in each file, e.g. file1.xls, file2.xls, file3.xls,
gt; .... file100.xls.
gt;
gt; Just wonder if there is a way in Excel (2003) to merge or concatenate all
gt; these similar files into 1 new-big excel file so I can do analysis over this
gt; 1 file instead of 100 files???
gt;
gt; Thanks in advance!!!
gt;
gt; John Lin
Oops

Wrong thread

--
Regards Ron de Bruin
www.rondebruin.nlquot;Ron de Bruinquot; gt; wrote in message ...
gt; Look also at the templates
gt; www.rondebruin.nl/mail/templates.htm
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Johnquot; gt; wrote in message ...
gt;gt; Hi,
gt;gt;
gt;gt; I have hundreds of excel files under 1 folder with exactly same # of columns
gt;gt; and same column names in each file, e.g. file1.xls, file2.xls, file3.xls,
gt;gt; .... file100.xls.
gt;gt;
gt;gt; Just wonder if there is a way in Excel (2003) to merge or concatenate all
gt;gt; these similar files into 1 new-big excel file so I can do analysis over this
gt;gt; 1 file instead of 100 files???
gt;gt;
gt;gt; Thanks in advance!!!
gt;gt;
gt;gt; John Lin
gt;
gt;
If you need to merge all the files into one, download this add in
www.asap-utilities.com/index.php?page=news.php
There is free and user friendly, there is a tool that will allow you to
merge files.quot;Johnquot; wrote:

gt; Hi,
gt;
gt; I have hundreds of excel files under 1 folder with exactly same # of columns
gt; and same column names in each file, e.g. file1.xls, file2.xls, file3.xls,
gt; .... file100.xls.
gt;
gt; Just wonder if there is a way in Excel (2003) to merge or concatenate all
gt; these similar files into 1 new-big excel file so I can do analysis over this
gt; 1 file instead of 100 files???
gt;
gt; Thanks in advance!!!
gt;
gt; John Lin