I want to select a particular value in a field based on a condition while opening the sheet.
Say for example...
In sheet1, I have Category field which contains the values - Cat1, Cat2.
If the user selects Cat1 it should activate the sheet "Cat1" if user selects Cat2 nothing should be selected in the Sheet "Cat1" when user moves on to the sheet "Cat1". Is it possible with the triggers?
I tried to use "Clear Other fields" in trigger but it is not working in QV9...I couldn't use Clear All since I need other selections needs to be carried to that sheet...