View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
esmith@atmc esmith@atmc is offline
external usenet poster
 
Posts: 1
Default Linking information in individual cells spanning multiple sheets

I am attempting to establish a link between two specific pieces of
information spanning 2 sheets in an excel document. The closest I have come
is using two hyperlink functions to point to the corresponding cells on each
sheet (i.e. One link points to the cell on the other sheet, a link in that
same cell points to the cell with the original link). However my problem is
that if new rows or columns are added or if old ones are deleted the links on
the other sheet are thrown off. I need some sort of hyperlink function that
points to the information in the cells & not the cell itself. Please advise.