|
|
#1
04-24-2011, 03:53 AM
|
|||
|
|||
Repeated Cells in different sheets
Good Day,
I have a monthly report all the cells are identical for each month. I would like to create an annual report. Instead of putting JanA1+FebA1+MarA1....DecA1, can I have a better solution. Thanking you in advance. 
|
|
#2
04-24-2011, 03:33 PM
|
||||
|
||||
|
Hi mhdagtas,
You could use a 3-d formula. See "Create a 3-D reference to the same cell range on multiple worksheets" in Excel's Help file.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Mail Mege Images - Path Correct but Images Repeated
|
Sonia Sosa | Mail Merge | 8 | 04-22-2011 03:05 PM |
|
How to syncronize data in two different sheets
|
diegogeid | Excel | 2 | 09-30-2010 12:19 AM |
|
Forumla between mulitple sheets
|
Phylis Sophical | Excel | 4 | 08-09-2010 08:43 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
| Calendar Events Repeated Many Times | johnmacek | Outlook | 0 | 08-21-2009 04:43 PM |
Windows Vista 
Office 2007
Linear Mode
