Merge two excel files

[aliasger.q]

Hello Everyone,


I have 2 excel files, one for weekly transfer report of branches and secound for weekly sales report òf branches. is it possible to merge two excel files based on common column barcode.

i just eager to know in excel because i can do this using sql query easily without any problem.


thanks for advise.

 

[Luke M]

I'd recommend checking out Ron's section on Copy/Paste/Merge.

http://www.rondebruin.nl/tips.htm


Also, XL supports using SQL queries, so you could use that as well. Queries are found under the Data menu.

 

[aliasger.q]

Thanks for your quick respond.