in my quest to create an unbeatable link between person and parents, i'm thinking to use instr with substring and string:
it could work like this :
i click on a cell starting a macro.
the active row is the person for whom we search the mother. (forex. mine: row 2)
we copy the value of column CP in the active row that contains the name
we search column B to find the name as a double string (column M & column N)
the macro ends with selecting that cell in column B ... (forex. in row 144 my mother)
who can fix that ...
thanks for the help !!!