Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to realize next process?
1. User selects his years in sheet 'Dashboard'
2. User goes to sheet 'Planning', where we don't use filter 'Year'.
The current selection box has to show all selections, excepts filter 'Year'.
3. When the user leaves sheet 'Planning' the selected\saved years of point 1 has to be working again.
Below one of the many options I tried to solve this. I don't know how to solve point 3 of the process.
Please let me know if there is a better solution to achieve above process.
I manage to make OnActivateSheet triggers in sheet 'Planning' to set the variable of year selections (see blue text box) and clear field 'Year' (see list box Year) for the desired presentation of the current selection box of point 2. But how do I realize point 3 with the OnLeaveSheet trigger? Is it possible to activate the year selections variable (vYearSelected) again, so the user can work further with the selections of sheet 'Dashboard' made in point 1?
Sheet properties 'Planning'
Document settings, sheet Variables
Accepted Solutions