I have five columns that contain the names of the people that pay me a
monthly fee. I have twelve rows, one for each month. I have it set up that
when I select the cell for a client for the current month a €œcheck€� mark is
placed. (This is done via a Worksheet_SelectionChange macro) I then use an
€œIf€� statement [=IF(B7="P",$B$5,"")] that references a cell with what each
client pays each month to determine my total monies received for each month
based on those €œCheck€� marks. All this works fine. The problem I have is
when I need to change the amount paid each month by changing the amounts in
those abolute referenced cells it changes all the months already paid,
because of the Absolute References. Short of just entering the amounts
received each month how can I lock in those months already paid and change
that amount paid for the balance of the year? This may happen only once a
year, and it may happen once in a couple years. Any ideas on changing my
setup would also be appreciated if it will fix my problem.

xl 2000

Mike Rogers