Hi all,
I have created a couple of conditional drop down lists (via data validation), and wanted to know if I can reset a cell when the value of a list is changed.
EG:
Cell A1 and B1 have list boxes. The options in B1 are dependent on the selected option in A1. This works great.
What I want is that if I have selected option from A1 and B1, then change A1, cell B1 should requery or set to null.
Is this possible?
Thanks for any assistance
Bookmarks