#1
|
|||
|
|||
How to manage some sheets and sub-sheets?
Hi, I have some information for different years and different months. To manage these sheets easier, I want to merge different sheets of months for every year in one group. For example, I make a pic with Photoshop to clear what I want, so I can have two pan: one for different years and other for different months of the opted year. For April 2014, I should click on 2014 and the click on April. I know this picture is fake and in normal situation I should have these sheets in Excel like the second picture; but is there a way to manage sheets like this? If not, what can you propose to manage some sheets. Thanks for any help |
#2
|
||||
|
||||
You'd do better to have all the data on a single sheet. Another sheet could be used to summarize annual data for any given year and yet another sheet could be used to summarize monthly data for any given month. Having separate sheets for each month and/or year just makes analysis harder than it needs to be.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks, but I cannot summarize data and I need it thoroughly. In addition, the date for every month has more than 30 rows and 60 columns and if I want to have all the data in one sheet, the sheet of every year will have 30 rows and (60*12 month) 720 columns and is so confusing, because to find data for a month, I should navigate in 720 columns but If I could group sheets of months of any year (such as the proposed picture or any similar solution), it will be so easier.
Is not there such a way? |
#4
|
||||
|
||||
If the data for every month has around 30 rows and 60 columns, having all the data in one sheet should only account for around 360 rows and the same 60 columns, not 720 columns. Since Excel can handle 1,048,576 rows, that should be enough for around 2900 years...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Is there any difference between writing data in 30 rows and 720 columns or 360 rows and 60 columns? As I am a newcomer, cannot distinguish any difference. I write the data for different month in front of each other and not below. Is it wrong?
|
#6
|
||||
|
||||
In Excel 2007 & later, the maximum worksheet size is 1,048,576 rows by 16,384 columns, meaning it has 64 times as many rows as columns. The normal way of populating workbooks with periodic data is to lay it out with columns for the data types and rows for the periodic data. Your existing data can probably be transposed to conform to that layout. There are many advantages to using the normal layout, including being easier to traverse, analyse, tec.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Thank you so much.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel sheets | ubns | Excel | 4 | 04-15-2012 10:48 PM |
Copying sheets | DavidSNPCPA | Excel | 2 | 01-19-2012 03:54 AM |
Balance from different sheets | andre | Excel | 0 | 11-29-2011 02:36 PM |
Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
Repeated Cells in different sheets | mhdagtas | Excel | 2 | 04-27-2011 12:02 AM |