Hyperlink probelm
I have a spreadsheet with a couple of worksheets, in one of the
worksheets I have a hyperlink to a specific cell in the other
worksheet.
e.g. Cell A1 in worksheet 1 has a link to cell A2 in worksheet 2 (with
the text 'Phone' in it). If I was to insert a row above row 2 in
worksheet 2, I still want the link in worksheet 1 to take me to the
cell with the text 'Phone' in it (Which is now A3 after I have inserted
the row).
I realise I can go and change the link manually, but the example above
is a simplfied version of my document and inserting a row moves about
30 hyperlinks!!!
Any help would be greatly appreciated.
Cheers
Glenn
|