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

I am not sure why you would need a macro for this. On the face of it, only simple calculations are required.

What are the relationships between A, B & C?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thank you for the reply. I apologize it took so long for me to get back to you.

I was thinking the same thing...I'm not real sure how to do go about that either.
A(current) is the only cell that doesn't change.
B(If B is changed, cells "C and I" need to calculate.
If they change C the cell B and need to calculate.
If cell I is changed then cell B and C need to calculate.

It doesn't look like I mentioned it above, but these cells are already populated, and there won't be any set way they enter data, so it just needs to be fool proof where it can't be broken. (They need a way to revert the numbers if they don't like the ending figures as well.- Essentially what they will be doing is playing with numbers. )

I think where I'm really struggling is if they change a cell that has a formula in it, and decide they don't like it, so they play with the other cells, then they have wiped out the formulas.

Thank you again. I do appreciate the help!