MERGE FILES

[sudipto3003]

I have more than 100 xlsx files in one folder, each file having 3 sheets, the data in each file and in each sheet having same number of column(A to V) but number of rows are not equal, now I required to merge all those files in one file having 3 separate sheets as already have, means all the data of those 100 files of sheet1 in sheet1 at merge file and so on for sheet2 and sheet3. please help..........

 

[srinidhi]

This query is already replied in this forum, please check the forum posts.


This is the heading in this forum


Macro required for merging all excel files in a folder

 

[sudipto3003]

sorry, but i am not asking for merging in a folder, i am looking for merging all my files in a single file

 

[keymaster]

Still same answer. Please search...

 

[NARAYANK991]

Hi Sudipta ,


Will this help ?


http://chandoo.org/forums/topic/how-to-compile-the-excel-file#post-49475


Narayan

 

[sudipto3003]

YES I HAVE GOT IT NOW, THANKS