Delete adjacent cell

[kryt0n]

Hi,

please see the .xls attached.

I have 4 coloumns each with a named range list.

Titles in Row 1. Contents in Row 2.

I want it so that whichever of the cells you select then DELETE OR CHANGE then all following cells become empty. If you change C2, then D2 becomes empty. If you change A2, then B2, C2 and D2 become empty.