xl2002 added an option to search through the workbook.

You may want to try Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

It'll work for all versions.

Susanne wrote:

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

--

Dave Peterson