VBA Preventing duplicates

[Kankoni]

Hi all,

I'm new in this website and just registered. I have got one question and would like your help.

How to prevent duplicates data to be copied in a range ?

On other words, how to tell Macro not to copy data that already there in the range?

Best regards.

 

[Joe4]

Welcome to the Board!

More details are needed.
How many columns are your data?
What constitutes a duplicate (do all columns need to match, or just certain ones)?
How exactly is the data being copied? If by VBA code, please post your code.