update formula in column when another cell formula is changed
 

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!

update formula in column when another cell formula is changed
 

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*(Z90) +AJ7*(Z91) +AR7*(Z92) 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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Susanelm" wrote in message
...
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!