If I have on the tab "MASTER" a item in column A that is referenced by other sheets... and this item on the master sheet gets deleted, I want to make sure it is deleted in column A of the other sheets referencing it. I don't want to delete the row from the other sheets, just delete the value in column A cell of the other sheets potentially referencing it.
On the attached example;
Sheet: MASTER has a item 3
Sheet: A has item 3 selected in row 3
Sheet: B has item 3 selected in row 3
If I delete item 3 from the MASTER I want some VBA to go through and clean it up from column A in the other sheets.