Compare Two Columns In Two Worksheets To Copy And Paste A Third Column

[uopint]

I have two worksheets: W1 and W2.

1. W1 has data in Column A, while W2 has none in that column (except for the header row of course).
2. W1 has rows that W2 does not have, and vice-versa.

I need code that will compare two columns in these two sheets. If the data in these two columns for a particular row match between the two worksheets, then for that row, I need the macro to copy the column A cell in W1 to the corresponding column A cell in W2. Finally, I would like an 'x' be placed into a W1 column if a match was found for that row.

The two sheets do not have the same number of rows, but the data being compared in the two columns should combine to form a unique row match between the two worksheets.

Thanks in advance to anyone who can help.

[Reafidy]

THis is a Cross Post