Counting the number of matched cells and adding it to a different number...

Hi Guys,

The macro I am trying to create should be fairly simple, I've started a macro but I can't figure out how to write it correctly.

Basically, I need it to cycle through a list of names and match them to a list of names in a different sheet but count how many times the name appears in the sheet and then add this number to the original list on top of the number that already exists in the counter column.

It's much easier to show in the file itself, please checkout the attached file.

Also here is my bad and not working macro as I can't figure it out:

Please Login or Register  to view this content.

Wow, that works impressively fast. I'll try it in my main sheet when I'm home but I'm pretty sure that's perfect.

Thanks for your help!

Try this:-

Please Login or Register  to view this content.

Regards Mick

Maybe:

Please Login or Register  to view this content.

Three different versions, which ones best... how would I tell?