Hi

I have a clear all macro that clears a range of cells that give a running total in another cell (B3). When I clear the other cells (B3) is also cleared because of the functions. This clearing is done to start a new year. I would like to keep a yearly running total in another cell (N4) when the year 2010 is entered into cell (M4) and the same when the year 2011 is entered into cell (M5) that total is then in cell (N5) and so on without having the previous cells in the yearly totals being cleared.

I would appreciate any help. I am really new at this. I hope I have explained it well enough.
Thanks