Hi,

I have the 1000 different excel file, each file have multile no of
sheet in it. but all the 1000 different file have the same format, only
the no of rows in each files will change but the no of columes remain
same.

I need to merge all the 1000 files into one file, which will have same
structure as the earlier one, merged file will also have multile
worksheet in it, same as the earlier structure of the file.


--
vikasmore
------------------------------------------------------------------------
vikasmore's Profile: http://www.excelforum.com/member.php...o&userid=31958
View this thread: http://www.excelforum.com/showthread...hreadid=516807