Search Multiple Worksheets by having user type in information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to create the following? I have multiple worksheets
with data for numerous calendar years. I want a user to be able to Enter a
"Last name" in a cell, hit enter and have the following results displayed:

1. finds the name or names and directs them to the speciific Worksheet(s)
or
2. does not find that name and leaves the cell blank.

Thank you
 
Hello,
I was able to find and use a very simple solution to search all worksheets
within a workbook. The users will be shown how to do this.

For now this is an easy solution.

Searching for a specific name in the Workbook within multiple worksheets:

1. Select Edit, Find
2. Within Find What – enter the last name eg.: Smith
3. Change Within cell to “Workbook†and check “Match Caseâ€
4. Select Search “By Rowsâ€
5. Click on Find All
Item is found
If name is not in Workbook, message is displayed advising this.
 
Back
Top