How can I hyperlink to a relative address in a worksheet?
 

I have built a work-in-process worksheet that I have linked to various
websites or email addresses, etc. One function that is not working for me
though is trying to link to another worksheet in the same workbook. I need
the hyperlink to be a relative address because I am continually resorting the
info in alpha order; so the cell I want to link to changes frequently. I
have tried naming the cell but to no avail. Can you help me?

Thanks,
Joan