I currently have a monthly budget worksheet that has 12 monthly tabs at the the bottom. As we move into the new year, I will create another 12 tabs, but want to "hide" the previous 12 into one "2012" tab.
Much like I can group rows and get the "+" symbol to expand the hidden rows, I would like to do the same with the worksheet tabs. Possible?
Thanks in advance - Dennis
Hi,
There's no inbuilt functionality similar to the Grouping for rows and columns that you describe. You could however have macros do the same thing. Something like
And a similar one for unhiding the sheet with .Visible = True
Please Login or Register to view this content.
This uses the sheet code name and assumes they are Sheet1, Sheet2..etc. You will probably need to change the loop counter to say 2 to 13. etc.
For the future however, are you really sure you need separate sheets for each month. Why not consider a single sheet but with an extra column to hold the month reference? Then you can use Data Filter to view your data and you will simplify immensely any reporting you want to do across months. And you'll also open the whole world of Pivot Tables which will let you summarise and analyse in ways you've not yet thought of.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Dennis
How are you naming the tabs?
If posting code please use code tags, see here.
I had them 1-13, but I think I'm going to just change the format of the sheet and make it so I can group and hide the rows and put the entire year on one sheet.
Would still like to find a way to group tabs together though.
Thx - dm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks