Creating worksheets within a worksheet
I want to be able to track data over a period of time. I will have a tab for
every day of the month. What I want is to be able to create additional tabs for each week and then one for each month. When I'm done I would like to see tabs for each month only. When I click on "January", it in turn will show me the tabs for the 1st - 31st. I have tried to figure this out but haven't been successful. |
Creating worksheets within a worksheet
You can't nest or embed worksheets within other worksheets from the same
workbook. If you put the daily sheets in a separate file for each month, those workbooks could be embedded as objects in the monthly sheets in your 'master' workbook. In terms of memory and disk space, you would be better off just adding hyperlinks to the daily workbooks. Hope this helps, Hutch "waldeck" wrote: I want to be able to track data over a period of time. I will have a tab for every day of the month. What I want is to be able to create additional tabs for each week and then one for each month. When I'm done I would like to see tabs for each month only. When I click on "January", it in turn will show me the tabs for the 1st - 31st. I have tried to figure this out but haven't been successful. |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com