Hey! Here's my situation:
I have 12 checkboxes that correpsond to different months. When a box is checked, that month's data is visible. When it is not checked, it is hidden.
Users have control over these checkboxes. However, if a cell contains a trigger value, I want that month hidden automatically.
So let's say we're looking at stats for Person A. We have Jan thru April checked.
Then we switch to Person B (data populates in place of Person A's), and Person B has a trigger for January. I want January to become hidden (by checking the Checkbox). And when we switch back to someone without a trigger (like Person A), I want January to re-appear (because that's how the user had it originally).
I have 12 checkboxes that correpsond to different months. When a box is checked, that month's data is visible. When it is not checked, it is hidden.
Users have control over these checkboxes. However, if a cell contains a trigger value, I want that month hidden automatically.
So let's say we're looking at stats for Person A. We have Jan thru April checked.
Then we switch to Person B (data populates in place of Person A's), and Person B has a trigger for January. I want January to become hidden (by checking the Checkbox). And when we switch back to someone without a trigger (like Person A), I want January to re-appear (because that's how the user had it originally).
