View Single Post
 
Old 04-14-2017, 06:28 AM
kbdinkin kbdinkin is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2017
Posts: 1
kbdinkin is on a distinguished road
Default 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
Reply With Quote