Find duplicate from mulitple sheet

**candyfreak** · 10-18-2012, 05:18 AM

I found a sample workbook which you can find duplicate and copy them in other worksheet.
But in this sample, the row without a duplicate also appear in the "DUPLICATE Report" tab. and count 1 as. but the duplicate appear as 2.

I need only the duplicates to show. I don't want to see entries without match or duplicate in "DUPLICATE Report" tab and the only thing I want to see are the entries with duplicates.

Please Help. Thank you.

**mnjofra** · 10-18-2012, 06:45 AM

Hi, try this code...
Main idea is not to change your concept of consisting duplicate sheet, just to delete all rows where G column is 1.

Regards,

**candyfreak** · 10-18-2012, 09:04 PM

Thank you so much. You are Awesome!!

I have a follow up question. What if I add columns? and I also want it to appear in DUPLICATE REPORT? How will I do it?
and do you know any way to make the searching (running) faster?

Thanks again.

**mnjofra** · 10-23-2012, 06:10 AM

Hi,
I was absent last days, sorry for answer delay. I made some changes in code, so right now is much more quick than previous version. I also put two comments in the code what is need to change if you insert additional columns in your sheets. Get this...

Best regards,