Repeated Cells in different sheets

mhdagtas · #1 04-24-2011, 03:53 AM

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.

macropod · #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.

mhdagtas · #3 04-27-2011, 12:02 AM

Thank you.

I managed to get it.

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