How do you selectively merge two workbooks?

Hello All,

I am having a ton of trouble combining two sources of data in Excel 2007. I need to add data from one worksheet into another.

The real problem with this is that the information must validate to one column. Here is an example of what I need to do:

I have a file, sheet1.xlsx. It contains 500 lines, and 4 columns, one of which is "Product Code" then the others are various bits like description and brand.

Then I have file two, sheet2.xlsx. It has 2000 lines, including the 500 from sheet one, but has 20 columns, including Product Code, then it has weights, dimensions, and a wealth of other info for each part.

What I need is to add the weights and dimensions to the lines of sheet1.xlsx.

Help me out of the madness, and tell me what to do! I have been researching all day about external data sources and the "compare and merge" command, but still havn't figured out how to do this.

Any help would be greatly appreciated.

Ok, here is a sample of the data that I am working with.

The goal is to take the weight, dimension, and brand data from each part out of the file named "PartData" and add is to the file named "WebDatabase".

The common information for the cells to align on is the "product code" column of each line.

I read up on something called Mail Merge with Microsoft Query, has anyone used this? Would it do what I want it to here?