LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CCR Clustering Rafavic Excel Discussion (Misc queries) 3 May 9th 08 02:45 PM
How use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? TS Excel Worksheet Functions 2 December 27th 06 02:49 PM
K-mean clustering CL Excel Discussion (Misc queries) 1 September 26th 06 01:31 PM
clustering Karim Excel Discussion (Misc queries) 0 January 11th 06 06:00 PM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"