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

Hi


You could copy al previous related cells and paste them as text, making the information fixed. Then change the value to the new amount so that the new values are still based on the same formula.

TabH

Hi and welcome

what triggers the fee change? The month or some other condition?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post