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.

Linking information in individual cells spanning multiple sheets
 

Instead of using the address of the cell you want to link to, give that cell a
nice name (insert|Name) and use that in your hyperlink.



esmith@atmc wrote:

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.

--

Dave Peterson

Linking information in individual cells spanning multiple shee
 

I did not realize you could do that. That did the trick. Thanks.

"Dave Peterson" wrote:

Instead of using the address of the cell you want to link to, give that cell a
nice name (insert|Name) and use that in your hyperlink.



esmith@atmc wrote:

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.

--

Dave Peterson