how do I join multiple excel files into 1 file?

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Merging from an Excel file with graphics 1
adding vlookup into Macro and table_array is different every week. 1
Embed the same Excel multiple times 0
Merging 800 Excel files 1
combining data from several excel files into one file 3
how do i loop thru all the worksheets in 2 files one by one 0
Executing a .BAT file using excel macro 1

Top