Avoid Duplicate Names

Hi,

I'm having at least one issue with this script below. Maybe more...the script is suppose look in Range A3:A100 for the last name that was just entered. if it finds the same name it then needs to look in Range B3:B100 at the first name, if both match a name that is already there then the cells are cleared and the user is asked to try again.

What I found out so far is that cell that the data is entered on is always going to be in the list so it will always find a duplicate.

I need a way to see if the name is listed more than once.

Can someone advise?

Thank You, Mike

Please Login or Register  to view this content.

Maybe you could try posting a sample workbook so the concept is clearer. I'm confused as to where exactly you are entering the last and first names.