Guidance to creating a code or formula to search for a name and/or change

Hi,

I have created a form that will add the information entered to the correct tab (I have this formula already (included below)).

What I want to do is once the submit button is select to search the workbook for the name to find if the person already exists, if the person does exist then a notice can pop up to stating, "This person already exists on "AREA""?

Code for moving the form data to the exact tab.

Please Login or Register  to view this content.

Many thanks for any help.

K Stevens

Hi, is it so that this person's name is somewhere in the Form sheet in Range("D10:D75"), where you want to check if it already exists on any other of your worksheets, or particularly in the target range defined by D5 and D6?