HYPERLINK
 

I am trying to use the hyperlink function but to no avail. Basically, I want
to hyperlink names in one worksheet to that same name in another worksheet.
i.e. I have the name JOE in worksheet 1 and want to link it to JOE in
worksheet 2. And, I have a huge list of names that I want to link in this
way. I can't get it to work. can anyone help???

Thank you!