tartanthing
New Member
- Joined
- Mar 4, 2022
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
I have a whole series of worksheets in a single workbook split in to groups then sub groups. EG Main Worksheet will be 1000 to 2000 with several hundred entries per worksheet going up in increments of 100, so the next group will be 1100, 1200, 1300 etc. those are then split further into 1100.1, 1100.2, 1100.3.
I've seen other workbooks (sorry, tried to find an example I thought I had downloaded) where the only tabs you see are 1100,1200,1300. When you click on a tab-eg 1100 it expands to reveal 1100.1,1100.2,110.3 etc, click on the 1100 tab again and it all contracts and hides the sub groups.
I cant for the life of me find a way to describe this in search which doesn't give me a video or tutorial telling me about groups and altering data. That's not what I want. I just want to clock on a tab and have the next worksheets expand or contract back to the main sheet.
Can someone please help, preferably without VBA? I need to be able to send this off to others to use without having to doomscroll through each open tab to find the right one.
Thanks for your help!
I've seen other workbooks (sorry, tried to find an example I thought I had downloaded) where the only tabs you see are 1100,1200,1300. When you click on a tab-eg 1100 it expands to reveal 1100.1,1100.2,110.3 etc, click on the 1100 tab again and it all contracts and hides the sub groups.
I cant for the life of me find a way to describe this in search which doesn't give me a video or tutorial telling me about groups and altering data. That's not what I want. I just want to clock on a tab and have the next worksheets expand or contract back to the main sheet.
Can someone please help, preferably without VBA? I need to be able to send this off to others to use without having to doomscroll through each open tab to find the right one.
Thanks for your help!