Does anyone know how to create a macro that will automatically search another
worksheet for a name and then enter in a third item once it finds the name.

For example: Search entire worksheet 1 for "John" then enter in the date
that John's name is under?

Is this possible? HELP PLEASE!!!