compare sheet 1 with sheet 2 and copy unique values in sheet 1

Hi friends

I am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.

Please Login or Register  to view this content.

Thanks in advance. Please help.

Hi irfanparbatani,
maybe so

Please Login or Register  to view this content.

Originally Posted by nilem

Hi irfanparbatani,
maybe so

Please Login or Register  to view this content.

===

Hi Nilem

thanks for replying, I have 2 workbooks and I have to compare sheet 1 of file 1 to sheet 1 of file 2 and delete duplicate from file 1 sheet1 if it is found in file 2.

Thanks for helping.