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 !!