amandaj1224
New Member
- Joined
- Nov 3, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
For example, I have a workbook I use to enter data from my daily work deposits. Each sheet n the workbook has a single days worth of data. We run on a period schedule of 4 weeks. I would like to be able to create a sheet called "Period 1" and hide all of the date sheets within the specified period as sort of a sub sheet if that makes sense. So that way at the bottom of my excel all I see is period 1, period 2, etc. Then I can click the main sheet and it will display all of the date sub sheets.
For example this is my sheet. My best solution as of now is a separate workbook for each period of the year but if I can create sub sheets I can have it conveniently all in 1 workbook.
View attachment 25435
For example this is my sheet. My best solution as of now is a separate workbook for each period of the year but if I can create sub sheets I can have it conveniently all in 1 workbook.
View attachment 25435
Last edited by a moderator:
