Hello!

I need a MACRO that will compare 2 (or more?) sheets from the same work book. Each sheet has a common ID (column A). Other than that, all columns are different with different data. What I need to to do is is combine (merge) all columns from different sheets with the same ID. The problem that one both of the following could be true:

1) The IDs may NOT be in the SAME ORDER from sheet to sheet.
2) Some IDs that are on one sheet may not be on the other sheet (or visa-versa).

An example of what I need is:

Sheet1 data

A B
ID Desc
111111 This is description 1
222222 This is description 2
333333 This is description 3

Sheet2 data

A B
ID Price
222222 $5.00
111111 $7.32
333333 size:CW - $12.50;size:SW - $11.25;

Sheet3 (combined/merged data)

A B C
ID Desc Price
111111 This is description 1 $7.32
222222 This is description 2 $5.00
333333 This is description 3 size:CW - $12.50;size:SW - $11.25;

Thank you !