Applying Queries to merge two worksheets

Hi Robbie, thanks for your query. Have a look at this link:

http://www.exceluser.com/explore/msquery1_1.htm

Note you need to copy the individual sheets into one file (and then name the data ranges). Once you've got used to do this manually you can set up a template with the ranges already in place. Make sure you link the tables by their ID numbers and then simply select the columns you want your new table to include.

Hope this helps,

Anthony