Having a hard time with this one. Please help! - Trying to keep a change in a cell from affecting pr
Hi all,
Here's my situation:
I use excel to keep up with my customer's and their monthly support fees. However, once a year, their support rate increases and I want to be able to update my fee without it updating all of my past month's columns.
For example, say Bob started out at $100 monthly support fee rate. In his monthly support fee column I have 100 for Jan - <g class="gr_ gr_1152 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-del replaceWithoutSep" data-gr-id="1152" id="1152">Apr,</g> and then increases to 101.
Jan Feb Mar Apr May Jun Jul
=MSF$A1 =MSF$A1 =MSF$A1 =MSF$A1 =MSF$A1 =MSF$A1 =MSF$A1
When I change his fee from 100 to 101 it changes the data for all of the prior months. Is there a way I can keep this from happening?
Thank you so much for your help!
Kimberly
|