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!