View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Regina[_2_] Regina[_2_] is offline
external usenet poster
 
Posts: 8
Default Lock Hyperlink to cell in different sheet

HI.

I want to create a link from one cell to another cell in a different sheet
but same workbook. But how can I get the link to follow when adding rows in
the linked to sheet?
Ie. Cell A5 in sheet1 has a link to cell B7 in sheet2.
If I add 2 rows to sheet2 so my previous cell B7 is now B9. I want the link
now to go to B9 in sheet2.
Is this possible, and if so how?