Hello good people!
I'm creating a single spreadsheet for a daily report. Since there's a report every day, I've created 365 tabs each with a brief short date (01_01, 01_02, 01_03, etc)
It got me thinking... is there a method for hiding tabs based on date using the tab name as a filter? IE, since it's March, could it be made so that only tabs that start with 03_XX show? I'm thinking there isn't, but I've been surprised before in this forum
The end user will have hardly any Excel experience, so just hiding and unhiding tabs isn't feasible.
I'm creating a single spreadsheet for a daily report. Since there's a report every day, I've created 365 tabs each with a brief short date (01_01, 01_02, 01_03, etc)
It got me thinking... is there a method for hiding tabs based on date using the tab name as a filter? IE, since it's March, could it be made so that only tabs that start with 03_XX show? I'm thinking there isn't, but I've been surprised before in this forum

The end user will have hardly any Excel experience, so just hiding and unhiding tabs isn't feasible.