Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can somebody help me with the following problem:
When I enter the sheet 'Orders' I only want to see the orders with OrderStatus=O. I don't want to see the orders with OrderStatus=I.
This works with Sheet Properties (Orders) --> tab Triggers --> OnActivateSheet --> Button Edit Action(s) --> Action ' Select in Field' --> Field 'OrderStatus' and
'Search String' O. But when I select in other sheets more filters and this selection doesn't include orders with OrderStatus=O and I'll open the sheet 'Orders' again all my current selections are cleared. How do I solved the problem of clearing my current selections?
See the answered discussion of Show message 'No data to display' where I ask my requirements more clear.