combined multiple files with sheets

[sudipto3003]

Dear Friends,

I have more than 90 excel files in one folder and each files having 3 work sheets each. The data in each file and in each sheets having same headings, what I want to say that the number of data columns are same in each sheet and in each files but the number of rows are not same. The sheet names of every files are same like Sheet1,Sheet2 & Sheet3. Now I want a single file having those three sheets merging all the files. If possible in merge file the first column contain the file name. Sorry friends can't upload files, hope I have explained clearly what I am looking for.

 

[Somendra Misra]

Hi Sudipta,

You may look at below add-in

http://www.rondebruin.nl/win/addins/rdbmerge.htm

Regards,

 

[sudipto3003]

thanks somendra for the link its really helpful.

 

[Somendra Misra]

You are Welcome.

Regards,