Search function

[Calvinnie]

I am creating an employee directory, each department on a seperate sheet, I
have created hyperlinks to each sheet to search by department, Is there
anyway i can create a funcion on the main page to search the sheets by
employee name?

 

[Pete_UK]

By using data validation, you can have a drop-down list of your
departments, from which you can select one. You can also set up
dependent data validation, where you can have a further drop-down list
of employees, which depends on the department chosen in the first drop-
down. Debra Dalgleish shows how to do this here:

http://www.contextures.com/xlDataVal02.html

You could then have one HYPERLINK formula to enable you to jump
directly to the employee's details on the appropriate sheet.

Hope this helps.

Pete