Thread: Hyperlink to Text? Hyperlink to a Picture Embedded on a Worksheet?

Hi, there's gotta be a simple solution but I don't know what it is. I don't know OLE or VB or whatever programming that might make this happen.

Let's say A1 is text that says "Office Policies" and is hyperlinked to go to A60 where it also says "Office Policies." <----that part's easy.

But how can I configure the hyperlink so that if somebody inserts 3 rows between rows 1 and 60, and the text that says "Office Policies" is now in cell A63, that the hyperlink WILL GO TO A63 and automatically adjust for inserted (or deleted) rows?

If I could hyperlink to a thumbnail picture on the worksheet that says "Office Policies," that would be easy but I don't know how or if I can.

Excel 2007 and also 2003
Thanks for your help!
Jcj

Hello

It is easier of you use named ranges.
e.g.
Lets say the word "Office Policies is in Cel A60.
click it go to Formula menu - define name - give it a name like e.g. SAMPLER
Now go to A1 for your hyperlink

enter
=hyperlink("#SAMPLER","Office Policies")

now even if you insert rows it will search and go to the named ranged "SAMPLER".
HTH

In A1, use:

=HYPERLINK("#A"&MATCH("Office Policies",A2:A65536,0)+ROW(A1),"Office Policies")