Copying without duplicating

R

Richard

Could anyone help me with a macro that would Copy the
contents in Sheet1 Column A:A which will have duplicate
numbers, to Sheet2 Column A:A without duplicating the same
number twice. Thanks in advance
 
B

Bob Umlas

Select column A, use data/filter/advanced filter and check Unique values
Then use Edit/goto Special, select visible cells only, then edit copy, then
go to sheet2, paste.

If you record your steps, you'll have a macro.

HTH
Bob Umlas
Excel MVP
 
H

Harald Staff

Hi Richard

Menu Data > Filter > Advanced filter, check "unique items only". Now you'll
see only the unique items in your selection or list. There's a copy to
option there as well.

HTH. Best wishes Harald
 
Top