moving my cursor inside the same spreadsheet

**FDibbins** · 02-02-2014, 01:58 AM

Hi and welcome to the forum

Not sure if this will be a feasible option for you (depends how links you need?), but you could create a named range for the destination, and then use that in the hyperlink...
=HYPERLINK("#"&aa,"this goes to sheet2 A10") Where aa is a named range on sheet2

**DixieDoll11** · 02-05-2014, 01:49 PM

I have attached a sample that might help. I cannot use hyperlinks, because if you insert a line, the cell does not change... unless you know a way to have it update as rows are inserted??