berz
New member
Hello, I did a quick search through the forums and the interwebs but I wasn't able to find a solution (or atleast one i understood) to my problem.
Context:
I am currently putting together a register/list of items on sheet 1. Essentially coloumn A will have the major category, coloumn B the subcategory, and coloumn C subsubcategory.
On sheet 2 I will have a definition provided for each of the items on sheet 1. so coloumn A will be the term/item, coloumn B its definition.
What I want:
I currently want to hyperlink each item on sheet 1, to its definition cell on sheet 2. This is perfectly straight forward; i just use hyperlink function and link it to the other sheet, then type in the cell reference.
my problem:
My problem is that whenever there is any cell movement on sheet 2, either because i inserted a new row or deleted it, the cell reference for the hyperlink remains the same, even though the cells (and therefore definition) have shifted.
my question:
is it possible to create a more dynamic hyperlink that will cater for movement on the other sheet. Or will I be forced to do all my hyperlinks post-definition writing, and the protect the sheet from editing?
Thanks in advance for taking the time to read over my problem, and any help is welcome.
Context:
I am currently putting together a register/list of items on sheet 1. Essentially coloumn A will have the major category, coloumn B the subcategory, and coloumn C subsubcategory.
On sheet 2 I will have a definition provided for each of the items on sheet 1. so coloumn A will be the term/item, coloumn B its definition.
What I want:
I currently want to hyperlink each item on sheet 1, to its definition cell on sheet 2. This is perfectly straight forward; i just use hyperlink function and link it to the other sheet, then type in the cell reference.
my problem:
My problem is that whenever there is any cell movement on sheet 2, either because i inserted a new row or deleted it, the cell reference for the hyperlink remains the same, even though the cells (and therefore definition) have shifted.
my question:
is it possible to create a more dynamic hyperlink that will cater for movement on the other sheet. Or will I be forced to do all my hyperlinks post-definition writing, and the protect the sheet from editing?
Thanks in advance for taking the time to read over my problem, and any help is welcome.