Grouping Worksheets under Week Commencing Sheet

[NickM88]

Hello,

Currently have a workbook with three sheets Daily, Weekly, Hours.

Is there anyway I can have sheets/tabs where it is named WC 04/06/18, wc 11/06/18 etc, and when you click on them, you have your Daily, Weekly, Hours sheet?

 

[MisterProzilla]

There's no way to have multiple sheets contained within a single sheet, if that's what you mean, but there are ways to group ranges of cells within a sheet so that you can switch between them easily.

You can either select a set of columns/rows and click Data-Group, then you can hide/unhide them quickly by clicking the group buttons along the top/side of the sheet.

Or you can create buttons in each sheet and use VBA to show/hide certain ranges when clicked. That way, you can show one and hide the others with the same click.


Does that help?