| 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. |
| 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 | |||
Threaded Mode
