I have a spreadsheet that has 2 Validation lists. The first list is to
select an item for a group (example: animal, vegetable or mineral). The
second list is dependant on the first list and displays options available
for the selected group (example: animal is selected in list 1; cat, monkey,
horse, etc. is available in list 2). I have this part of the spreadsheet
working, put when I change the selected item in list 1, list 2 still
displays the last item selected prior to selecting a new item in Validation
list 1. Is there a way to refresh list 2 (or unselect the previously
selected item), after list 1 is changed?

TIA,

----------
Jim H