My extended address list, containing all possible data of the people i know does to my happiness all the things i like !!!
column M first name and column N last name for each person; and column Ax for the mother and column Ay for the father.
the cells in columns ax and ay, when containing a name, are made a hyperlink so that when clicked the row of the mother/father is selected.
that works perfectly !!! ... until rows are added of course.
I have tried to change the range in de named range list from $B$144 to B144 but that is corrected automatically. And thus the row numbers
do not adjust when rows are added.
How can i change the named range formula " =gegevens!$B$34 " to a formula that will adjust ?
or is there another way to make clicking on the mother's/father's cell name jumping to their row ?
curious if there is a solution !!!
and thank you for your time !!!