Compare worksheet and list the number of duplicates

[jericlapuz]

Hi Everyone,


Need some analysis where do I went wrong with my code.
I want to compare the data in one workbook and list the duplicate in another workbook. I've come up with this code but the duplicates never counted.

Please Login or Register  to view this content.

I've also attached the file that I am working with

Hope someone can help me to deal with this.

Regards,
Jeric Atraje Lapuz