Prvent Duplicates in Range A2:A100 while coping in to another sheet

Dear Expert

I have a two sheets first is Data Entry & second is Data Sheet i want a macro to prevent duplicates value in Range (Data Entry A2:A100) while updating the data sheet (range A2:A1048576)

The Excel sheet is attached for reference.

Please Login or Register  to view this content.

Your help in this regards will be highly appreciated
Thanks in advance
Vaibhav

Dear Sir,

Thanks for your valuable reply, but can you post this code in my attached workbook, i am very new in VBA hence enable to understand code

Thanks
Vaibhav

Dear Sir,

Thank you, but data not copying on sheet2, please look into

Regards
Vaibhav

Dear Sir,

Thank you very much the code is awesome, but one more thing is required

i don't want to copy duplicate values of column A (Data entry sheet) to data sheet

if product code already exits then popup the message " This product code is already exits please try another code"


if possible please help...

Thank you
Vaibhav

Dear Sir,

Superb, Awesome, Thanks for the help

But after a popup message duplicate values still copying to data sheet
i don't want to copy duplicate values of column A (Data Entry) to data sheet

If you could help that is very useful to me.

Thanks in advance
Vaibhav2312

Dear Sir,

Thank you, but duplicate values are still copying after popup a message.

The File is attached for reference.

Regards
Vaibhav

Thank you very much sir This is very Helpful to me.

i know i am asking very stupid question, but is it possible to duplicates cell values should not be clear.

Please Login or Register  to view this content.

Thank You
Vaibhav