Try this sample from my archives which illustrates a way:
http://www.savefile.com/files/1054222
Hyperlink item to table range below.xls

The sample uses this point formula to create the hyperlinks:
=IF(A2="","",IF(ISNA(MATCH(A2,B$20:B$200,0)),"",HY PERLINK("#"&CELL("address",INDIRECT("B"&MATCH(A2,B $20:B$200,0)+19)),A2)))

Try adapting it to suit. It'll work to find the match in/jump to another
sheet, too. Gotta go now ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dmshurley" wrote:
I have a worksheet named, "contact master" that has the name and address of
employees.

I have a second worksheet named, "master schedule" that has the names and
training schedules of employees.

I want to click on the name of the employee in the "contact master" and have
it take me directly to that employee's name on the "master schedule".

Hyperlink only allows me to choose a cell reference, which changes whenever
I perform a sort.