Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cobbbbbb
 
Posts: n/a
Default keep totals from month to month?


I'm not sure if I can explain this right, but here goes.............
I have a running total per month on one worksheet that gets added to a
monthly total on another worksheet. My question is, is there a way to
make the total on wrksht1 advance to the next cell in line on wrksht2
when the date changes monthly?
In other words I want to reset the total and advance to the next cell
only when I change months. Look at pictures maybe that will
help...........


+-------------------------------------------------------------------+
|Filename: Image2.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3481 |
+-------------------------------------------------------------------+

--
cobbbbbb
------------------------------------------------------------------------
cobbbbbb's Profile: http://www.excelforum.com/member.php...o&userid=24221
View this thread: http://www.excelforum.com/showthread...hreadid=378384

  #3   Report Post  
duane
 
Posts: n/a
Default


not sure if am reading the question right, but it looks to me like you
keep adding data accross the months in one row on one sheet, changing
the "date" and data every time. You want to freeze the total on the
2nd sheet when you change the "date". I think the only way to do this
is have a date associated with the input data - maybe row by row. Then
you can easily add up the data associated with the input month


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=378384

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add one month to the previuos month heater Excel Discussion (Misc queries) 5 February 10th 05 01:33 AM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 07:43 PM
Accounting Month vs. Calendar Month JN Excel Worksheet Functions 4 January 31st 05 09:09 PM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 04:07 PM
running totals in a macro for each month idunnobutheregoes Excel Worksheet Functions 1 November 8th 04 11:35 PM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"