Hi,
I have a financial tracking spreadsheet, and am wanting to setup of control button to hide and unhide certain Columns based on todays month.
The sheet has repeating columns labelled - July Forecast - July Actual - August Forecast - August Actual - etc - etc
Based on today, if the button was clicked, it would hide all the previous Forecast columns (i.e. July Forecast - August Forecast) but leave the Actuals showing. Clicking it again would Unhide them all.
I'm assuming this can be done by filtering by dates before the 1st of each month.
Thoughts?
I have a financial tracking spreadsheet, and am wanting to setup of control button to hide and unhide certain Columns based on todays month.
The sheet has repeating columns labelled - July Forecast - July Actual - August Forecast - August Actual - etc - etc
Based on today, if the button was clicked, it would hide all the previous Forecast columns (i.e. July Forecast - August Forecast) but leave the Actuals showing. Clicking it again would Unhide them all.
I'm assuming this can be done by filtering by dates before the 1st of each month.
Thoughts?