i have sheet1 and sheet2 and i have category name X,Y,Z,A,B
Now whenever i activate sheet1 i want X,Y,Z to be selected ans when i navigate to sheet2 i want A,B to get selected.
How to do it?
Note i dont have any list box so select all three together.
You can do "Settings" > "Sheet Properties" > "Triggers" > "On activate sheet"
Then add the selections you want
yeah i am doing the same....in trigger -> on Activate sheet -> Select field ->X
Select field ->Z
so it will show the last selected field Z and not X and Y
I am assuming X,Y,Z are in the same field. So only do one trigger, and select all 3 in that field in one go.
The syntax would be like this
Retrieving data ...