I am trying to clear multiple validation lists if one of two particular lists changes, but can't find the code to do this.
Basically, I want the following cells (which are each independent validation lists) to reset back to being 'blank' (B14,B15,B16,B17,B18,B19,B20,B21,B22,B26,B27,B28,B29,B30,B31,B32,B33,B34,B35,B36,B37) if either of two cells change (B20,B21).
If B20 changes, I also need it to 'reset' B21 to blank - but if B21 changes, B20 should not reset.
I hope this wasn't confusing, but appreciate your help.
This file will also end up being protected, so I need code that will this macro to run even when the sheet is protected.
Thanks
Brian
Bookmarks