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