update formula in column when another cell formula is changed

[Susanelm]

Hi !

How can I change cell formulas automatically when I change another cell.

For example say:
For June: A1 through A250 cell formula is =+B7+AJ7+AR7+BA7+BI7+BQ7
every month it will have a new cell added to the formula
For July, these cell formulas will be =+B7+AJ7+AR7+BA7+BI7+BQ7+BY7

I want to automatically update A2 through A250 formulas by only changing the
A1 formula.

I know that I could drag the new formula down from A1 but I have 10 sheets
that need to be changed and I would like to find a way to automate this to
prevent human error...(mine!).

Thanks!

 

[Bernard Liengme]

Sounds like VBA would be best
I assume the cells values are non-zero otherwise you could have the entire
list of cells at any time

One possible (ugly) formula is
=B7*(month(today()) >0) +AJ7*(month(today()) >1) +AR7*(month(today()) >2)
and so on
The you use the same formula year-round
or
=B7*(Z9>0) +AJ7*(Z9>1) +AR7*(Z9>2) and so on AND z9 having =MONTH(TODAY())

Shame the data is laid out in a more friendly way so we could use SUMPRODUCT
best wishes