Need to auto-delete cells based on condition

[traugotts]

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!

[Kaper]

I'd approach such task the following way:

in wkbk 2, in sheet with names event handler for Worksheet_Change event.
in this event handler: find what was previous value of changed name, locate this name in wkbk 1 in sheet with names, delete all info for that name, replace name with new one.

As for the beginner - one of "canned advices" (contained also in http://www.excelforum.com/forum-rule...rum-rules.html ): Attach a sample workbook(s). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic