VB Code to display and count duplicates

I am looking for a way to identify duplicates across multiple columns in excel, list each dplicate in another sheet, and display how many times each duplicate field occurs. (See attached fo desired results)

Thanks in advance.

Met

Hi Met. Try it

Please Login or Register  to view this content.

Nilem:

That works! However, is there a way to exclude non-duplicated fields? Rather the entries that have a count of one? I am attaching my actual spreadsheet with your addon attached to my macro. (the macro has been executed) As you will see, my vb knowledge lacks but it works. I also want to skip the first two rows because they are titles and it would be nice to name the new sheet something, is this possible? Thans for all your help.

Adendum:

I am only interested in the fields in column A for each of the sheets. (AKA the Lawson Item #) The other fields need to be ignored. I hope my poor explaination has not confused you.

Thanks,
Met

try this

Please Login or Register  to view this content.

Works like a charm! Kudos to both Nilem and Jindon.