copy to sheet by criteria

[armat]

I want to copy the data from that sheet ("datasheet") to another sheet ("sheet2"), but only if the data isn't already present (don't want multiple entries of the same data on "sheet2"). I have no problem copying the data to the other sheet but how do you avoid duplicate entries when the macro is run multiple times?

 

[vletm]

armat
#1 note: You have opened Your thread to Ask an Excel Question to copy...
But in the last sentence, You wrote about the macro ...
The thread should open to correct Forum.
#2 note: You've written about copy data from sheet to other and avoid duplicates (What makes Your worried duplicates?).
That would need a sample Excel-file with some sample data - to see - what do You really have there?
... with expected results too.

 

[pecoflyer]

And with a little browsing you will find lots of answers on the Net. This problem is far from new...