perfect named ranges do not move along with moving cells : HOW can i make a link that will adjust when rows are added later ?

  • Hello :)


    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 :) !!!

    __________

    Peter 'Little Pete' Dejaeger

    All I don't know yet, is a challenge ! :thumbup:

  • i cannot edit my post, so an addendum:


    to give you an example:


    my data: row 2. my mother's data: row 144. my father's data: row 171.

    column: B: first and last name. column ax: mother's name. column ay: father's name.


    so:

    cell ax2: link to my mother in cell B144; cell ay2: link to my father in cell B171.

    __________

    Peter 'Little Pete' Dejaeger

    All I don't know yet, is a challenge ! :thumbup:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!