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