View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vanarsdalet vanarsdalet is offline
external usenet poster
 
Posts: 5
Default Hyperlinking to another worksheet in existing file

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?