Hi, can anyone help with VBA code please? I have an excel file with lots of drop-downs in columns A-D, all dependent on column before. I want to change "child" columns if any parent changes so:
If A changes, it deletes* B, C and D
If B changes, it deletes* C and D
If C changes, it deletes* D
* Deletes or says "Please select..."
For simplicity, I have added a simple example here. Thanks in advance.
Bookmarks