Hello !
I have a question that looks simple in my mind, and I hope Excel has the ability to perform this, as it would save me significant time.
I will give a simple example:
Let's say I have a formula =C1-B1
For example C represents march and B represents february.
Next month, my monthly variance will become D1-C1 (april vs march).
I want to be able to have the reference in 2 cells and by changing the value in these 2 cells the formula would automatically.
I would have in one cell : C
and in another cell : B
I would want to change the first cell to D and the 2nd to C, so that my formula updates.
I know I could use the find & replace function but I am looking for an alternative solution to that which will save me a lot of time.
Thank you very much !!
I have a question that looks simple in my mind, and I hope Excel has the ability to perform this, as it would save me significant time.
I will give a simple example:
Let's say I have a formula =C1-B1
For example C represents march and B represents february.
Next month, my monthly variance will become D1-C1 (april vs march).
I want to be able to have the reference in 2 cells and by changing the value in these 2 cells the formula would automatically.
I would have in one cell : C
and in another cell : B
I would want to change the first cell to D and the 2nd to C, so that my formula updates.
I know I could use the find & replace function but I am looking for an alternative solution to that which will save me a lot of time.
Thank you very much !!