Hi,
I am not sure if these is possible but I currently have 1 workbook with 7 worksheets (1 for each day of the week). In the past, I would start a new workbook each week for that weeks data. However, I have now been tasked with creating 1 large workbook for each month.
With that said, instead of having 31-37 tabs on the bottom is there a way to group the worksheets together so that when Week 1 is selected it opens into just its 7 worksheets?
Thanks for your help!
I am not sure if these is possible but I currently have 1 workbook with 7 worksheets (1 for each day of the week). In the past, I would start a new workbook each week for that weeks data. However, I have now been tasked with creating 1 large workbook for each month.
With that said, instead of having 31-37 tabs on the bottom is there a way to group the worksheets together so that when Week 1 is selected it opens into just its 7 worksheets?
Thanks for your help!