Formula to change move down one cell
Formulas can't change other cells.
Ross wrote:
Hi All~
I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??
Much appreciated & I always leave feedback:-) Thanks!
|