merge multiples excel files data quickly

[majidsiddique]

Hi All,

can i quickly merge multiple excel files Data in single file? Heading should be same or different?

Thanks.
Majid

 

[My Aswer Is This]

how i can merge DATA from different excel files into one file?

I do not know how to do that.

And when asking questions like this you may get help if you provide specific details.

Like merge what files into what file.

So do you have 50 workbooks and want to copy all the data from 50 workbooks and all sheets into one sheet.

See these are the type details you need to provide.

And unless you want all Workbooks and all worksheets you would have to give the exact name of all 50 workbooks and a sheets.

 

[MARK858]

how i can merge DATA from different excel files into one file?

Hi majidsiddique, with the lack of info you have provided it might be worth you considering using an add-in like in the link below.

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

 

[majidsiddique]

Thanks MARK858:
i use it very help ful to merge excel files. but tell me one when we merge excel both file one have 2 sheet DATA and one have only one Sheet DATA, is it possible to merger them with sheet wise?
currently merge in excel new file one sheet paste all the DATA both files.
Thanks