Creating worksheets within a worksheet

W

waldeck

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.
 
T

Tom Hutchins

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top