ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating worksheets within a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/186190-creating-worksheets-within-worksheet.html)

waldeck

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.

Tom Hutchins

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