merging 2 files in excel

[lezawang]

Hi
I just watched a youtube video about merging 2 excel sheets into a one sheet. all sheets are in the same files. the merge was done using Data tab-->Get External Data group --> From other sources-->Excel--> Microsoft Query.

I tried to put these data into 2 different excel files and merge then and put the merge result into 3rd files but did not work. I only can merge then if they are into same sheet. Is that the condition?

Thanks a lot.

PS the video i was refering to is this https://www.youtube.com/watch?v=0uWjXuhvqB8

 

[arthurbr]

Perhaps try http://www.rondebruin.nl/win/addins/rdbmerge.htm or http://www.rondebruin.nl/win/section3.htm