Create link to specific word on different worksheet

[ymerryweather]

Hello,
Is there a way I can create a link in excel to go to a specific name on a different worksheet in the same workbook? I am trying to create a link in cell J4, Candidate Notes, that will located his name on a separate worksheet in the same workbook labeled CANDIDATE NOTES. Is there a way to do this? If I wanted this link to find his name anywhere in the workbook, is there also a link to do that?
Thank you in advance for your assistance!

 

[Herakles]

I have tested the code from mumps and it works fine for me which is baffling.

There may be something in your setup that causes it to fail.

Can you just create two new worksheets and add in some data manually and see what happens.

 

[ymerryweather]

I have tested the code from mumps and it works fine for me which is baffling.

There may be something in your setup that causes it to fail.

Can you just create two new worksheets and add in some data manually and see what happens.

Yes I will try that tomorrow as I have to leave for the day now. Thank you again for all of your help and sorry to have bothered you so much today!