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