| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Cells from Multiple Sheets | New Users to Excel | |||
| Excel cells spanning multiple printed pages | Excel Discussion (Misc queries) | |||
| Linking cells on between multiple sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Linking Information in Sheets based on its content | Excel Worksheet Functions | |||
Linear Mode
