duplicate detection

[ashishmehra2010]

Hi all,

I want to setup a code in such a way that whenever I tried to copy the data the macro should check all the sheets & if found exact then it should stop me if data is new then macro should not stop me from pasting the data.

e.g. there are some codes exist in various sheets; when some one try to paste new data then vba code should check for duplicate data. I do want any duplicate data in my workbook.

How can I avoid duplication as soon as I paste the data?

Regards,
AM

[ashishmehra2010]

Bump


Regards,
AM