there is a long list of data in column C sheet1
how can i copy that column to sheet2 column C by removing duplicate entries
The code that I have is
Code
sheet1.Range("C5" & sheet1.Range("C" & Rows.Count).End(xlUp).Row).Copy
sheet2.Range("C5").pastespecial
sheet2.Range("C5:C" & Range("C" & Rows.Count).End(xlUp).Row).RemoveDuplicates Columns:=1, Header:=xlNo
What happens is that if I am having 1500 or more entries, the entire 1500 entries is first copied and then duplicates removed.
What I am looking for is a fast VBA code to copy but not duplicates so that 1500 entries are not copied but only single entries.
The origional sheet1 entry should not be changed.