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
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.