Combine two sets of data by identifying duplicate value across two columns

[Marmaduke_88]

Using Excel 2007 -

I have two workbooks with data, with one column in common, and need to combine the two.

For example:

</SPAN>
and

</SPAN>

I need to copy the header to the other workbook, then find all duplicates between the "Number" columns, and where there are matches copy the row into the other workbook to the right of where the data leaves off (it'll be fixed, so it doesn't need to be dynamic).

The workbooks will be changing names, so it'd be best if it just goes to the next workbook instead of identifying workbook names.

Hopefully I've made enough sense for someone to help - if I've been unclear, please let me know!

 

[Marmaduke_88]

sorry if a bump isn't appropriate here!