Some relatively simple options:

Select the column with the name in it, go to Data, then Filter, and select
Autofilter. This will put a little red caret/arrow on that column with a
dropdown of all the various data in that column, you can select the name you
want and all records with that name will come up. To undo and view the sheet
normally, just go back to Data and uncheckmark the Autofilter.

Another way, which you've probably tried, is to do a Find (either ctrl+F or
on the Edit menu, do a Find). Then again, you'll have to keep entering on
that FIND to get all entries with that name.

"thom hoyle" wrote:

I have a large spreadsheet that is long in length. I must scroll until I find
that employee's info, sometimes 5-7 pages down...
Is there a way to use a DropDown that selects from my list of names then
"hyperlinks" me to the names cell in on the sheet.?

thanks