I am trying to run a macro when I select a new value from a list (set up
using data validation). Is there a way of doing this. The idea is to clear
certain cell entries when I make a new selection on the data validation cell,
so if there is another way without using a macro, that would be fine too.
Is there a way to do this?
Fiona