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?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
