I am a beginner here... FYI.

I have a workbook (we'll call it wkbk 1) with names linked to an outside workbook (wkbk 2).

In wkbk 1, I have individual data for each person named (information is listed as one name per row w/ that person's data in same row). If a name in wkbk 2 ever changes, then the names in wkbk 1 would also change, therefore I need the individual data to be deleted whenever a name changes. *Note, the name will never be blank, there will always be a name written.

Any ideas for this beginner?

You are much appreciated!