Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clustering worksheets
Help,
I have a workbook with four worksheets. These worksheets are NOT identical AND three of them feed into the fourth. This is good for one month of data. At the end of the year, I end up with twelve workbooks. Not so bad if you are only dealing with one set. I have about a hundred of these sets to manage each year. I could put four worksheets for each month in one workbook. That would be 48 worksheets. So many tabs makes navigation a little unwieldy. Is there any way to cluster (not group) the worksheets into 12 sets so that one could touch on February and only see the four worksheets for February? TIA! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clustering worksheets
A few options to think about:
1. I am a fan of consolidated data, so I would put all data for a particular month into one workbook even if it means having 48 worksheets. Although, there is many worksheets to to each month, you should now only have 12 workbooks. 2. Once I have just twelve workbooks or data at the end of the year, this data should not change. So, I would look at creating a summary wkst page in each workbook with a pivot table. Although you have 48 wkst's, 12 of these have consolidated data which the other wkst's feed. So these 12 wkst's with consolidated could feed your summary page. Or, you could take the data from these 12 wkst's and put it on one worksheet then have your pivot table feed from it. After I accomplished this on all 12 workbooks, I would probably look at creating a summary worksheet of all twelve months with another pivot table fed from the summary page of all 12 workbooks. Then you would have an overall summary page and one for each month. You could even insert links on your master summary page to automatically open each monthly workbook. 3. You could just record a macro performing the exact process of making each workbook look like you want it and use this same macro for all the other workbooks. You could record a macro opening each month and assign this macro to a button and give the button the name of the month it opens. That way all you have to do is press the button to open the month you want. Not sure I answered your question or not, but perhaps these options will help get you started. Good Luck. "Rotata" wrote: Help, I have a workbook with four worksheets. These worksheets are NOT identical AND three of them feed into the fourth. This is good for one month of data. At the end of the year, I end up with twelve workbooks. Not so bad if you are only dealing with one set. I have about a hundred of these sets to manage each year. I could put four worksheets for each month in one workbook. That would be 48 worksheets. So many tabs makes navigation a little unwieldy. Is there any way to cluster (not group) the worksheets into 12 sets so that one could touch on February and only see the four worksheets for February? TIA! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CCR Clustering | Excel Discussion (Misc queries) | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
K-mean clustering | Excel Discussion (Misc queries) | |||
clustering | Excel Discussion (Misc queries) |