How to make hyperlink "follow" a cell ?

[crave4excel]

Hello,

I was wondering if it's possible to create a hyperlink in Sheet1, that link it to a specific cell on Sheet2, AND also follow that cell whenever I add/delete rows on Sheet2?

My dilemma is that I have a hyperlink created and link it to let's say Sheet2 cell E10. But later on when I add more rows to Sheet2, that hyperlink remains at E10, and hence incorrectly links to the wrong cell.

Any ideas?

 

[shg]

=HYPERLINK(CELL("address", Sheet2!E10))

 

[crave4excel]

=HYPERLINK(CELL("address", Sheet2!E10))

Thanks shg. I forgot to mention that the cell in Sheet1 has already embedded with SUMIFS formula that links to another tab. I was simplying adding "Hyperlink" from the 'INSERT' tab. So unfortunately your method does not work in this case

 

[shg]

Name the target of the hyperlink.

Hyperlink, Place in This Document, Defined names ...