Hello all,

First off, let me just say that I am a non-programmer and do not know
anything about VB, but am hoping that someone here can help me out. I have a
formula in cell A75 and the cell references in the formula have to be changed
once a month, thus I would like to have a macro I can run each time the cell
references need to be changed.

An example of the formula is as follows:

Formula = SUM(D3,E4,F5)/SUM(C3,D4,E5)

Upon running the macro, the formula would change as follows:

Formula = SUM(E4,F5,G6)/SUM(D4,E5,F6)

and running the macro again, the formula would change to:

Formula = SUM(F5,G6,H7)/SUM(E5,F6,G7)


Much thanks in advance to anyone who can provide me with a solution to this.