I have a very personalised address list with all data of persons i know.
each row is person: colum Q date of birth; M first name; N last name; Y marriage date...
and : Co name of mother ; Cp name of father
I am trying to make the columns Co and Cp clickable so the active cell is placed on the name (column B) of the mother (when Co is clicked) or father (when Cp)
i have tried vlookup, match, index, match & index, but named ranges come the closest to a good result !
each cell B of a person, containing name, first name, nick name, age,... basic data who has children is a named range.
each child has the text "LINK : Anna Johnson" as a link to the mother, and the named range is then called: ouannajo (ou for ouders, parents; anna first four letters
of first name; and jo two first letters of last name) ..
that works perfectly ... but only until new persons (rows) are added !
i understand why: named ranges are fixed: ouannajo named range = $B$144 and not B144. thus the address doesnt change...
how can i fix that ???
thanks for the help !!!