Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
Creating worksheets | New Users to Excel | |||
Creating multiple worksheets... | Excel Worksheet Functions | |||
Creating old xls worksheets. | Excel Discussion (Misc queries) | |||
Creating a log with info from worksheets...... | Excel Discussion (Misc queries) |