Get Unique Date from two columns

Hi,

I am trying to write macro to get unique from two columns. Please find the example below

ColumnA ColumnB
A 1
A 1
B 1
B 2
B 2
C 1
C 2
D 1
E 1

I need out put in the existing another sheet as

ColumnA ColumnB
A 1
B 1
B 2
C 1
C 2
D 1
E 1


Regards
nikenav1

Try:

Please Login or Register  to view this content.

Same as selecting both columns, Data > Remove Duplicates, tick the columns.

Hi thanks, I need it in new sheet "Sheet2"