|
|
#2
11-14-2015, 11:37 PM
|
||||
|
||||
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] 
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode