Named ranges do not move when rows are added

Hello all

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

Quote from royUK

If your data is in a Table format then convert it to a proper Table, that way the data area will by dynamic and expand as rows are added.

Overview of Excel Tables.

Hello

I have tried to convert to a table, but i'm using all posibilities in excel (named ranges, macro's, titles, formula...) and already trying macro's i noticed

they don't work...

I can see the advantages, but there are, i think, toooo many disadvantages... a table is for math more then text i guess?

attached a little copy: me, parents and a few shops and royalty to give you an idea... check the columnx ax ay and all on the right side after column K

have fun !

hello

which sheet? the first in the file? data ("gegevens") ?