Hi. I've been looking for an answer and can't find what I'm looking for. I'm really new to this and could use any help I can get. Thank you in advance.

I have a spread sheet with columns

A= Current
B= Change Amount
C= New Amount
I= Percent Change


What I need is a code that If I were to change the value in "Change Amount" That it calculates a value in the corresponding "Percent Change"(from a formula).

But there will be times that the "percent change" value will change instead, therefore needing to update corresponding "Change amount" (also from a formula)

There is roughly 100 rows in the spreadsheet. It will always be a random cell in the range that changes, and sometimes more that one will be.

Is there an easy way to do this?
Thank you again for any help!
Don