Dear Team,
with attached the macro sheet, I am able to compare two columns from two different sheets and copy the duplicate records into another sheet.
But, I want the code to copy the entire row from source sheet if any record is not found in master data sheet).
Ex: If 123 is there in Source file under any column and the same 123 is not found in Master data sheet, Code should copy entire row which has 123 in Source file and paste in another sheet.
Hopw this will help you to modify the code.
Looking forward for your help.
Thank in advance for your swift help
Kind Regards,
Chandru
Bookmarks