how do I join multiple excel files into 1 file?

[Guest]

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

 

[Ron de Bruin]

Start here John
http://www.rondebruin.nl/copy3.htm

 

[Ron de Bruin]

Look also at the templates
http://www.rondebruin.nl/mail/templates.htm

 

[Ron de Bruin]

Oops

Wrong thread

 

[Guest]

If you need to merge all the files into one, download this add in
http://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.