Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2011, 03:53 AM
mhdagtas mhdagtas is offline Repeated Cells in different sheets Windows Vista Repeated Cells in different sheets Office 2007
Novice
Repeated Cells in different sheets
 
Join Date: Apr 2011
Posts: 2
mhdagtas is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-24-2011, 03:33 PM
macropod's Avatar
macropod macropod is offline Repeated Cells in different sheets Windows 7 32bit Repeated Cells in different sheets Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 04-27-2011, 12:02 AM
mhdagtas mhdagtas is offline Repeated Cells in different sheets Windows Vista Repeated Cells in different sheets Office 2007
Novice
Repeated Cells in different sheets
 
Join Date: Apr 2011
Posts: 2
mhdagtas is on a distinguished road
Default

Thank you.

I managed to get it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeated Cells in different sheets Mail Mege Images - Path Correct but Images Repeated Sonia Sosa Mail Merge 8 04-22-2011 03:05 PM
Repeated Cells in different sheets How to syncronize data in two different sheets diegogeid Excel 2 09-30-2010 12:19 AM
Repeated Cells in different sheets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft