Difficult: Removing duplicates between 2 sheets, or copying Unique rows.

Hi there everyone,

I'm having trouble with creating a VBA that removes the matches between ColA,sheet 1 and ColA,sheet 2 or copying the unique ones to another sheet.
The result should be that after the macro has completed, that all the matches that were in CA,S1 and CA,S2 are deleted and that the rows of the matches are deleted too.

Before:

col A(sheet2) Col A(sheet 2)
ss1 ss20
ss4 ss7
ss7 ss2
ss20 ss3

After:

col A(sheet2) Col A(sheet 2)
ss1 ss2
ss4 ss3


Could anyone please be so kind to help me?

With kind regards,

RonaldRS

Difficult: Removing duplicates between 2 sheets, or copying Unique rows.

BUMP

Difficult: Removing duplicates between 2 sheets, or copying Unique rows.

BUMP

Difficult: Removing duplicates between 2 sheets, or copying Unique rows.

BUMP