Cell formulas that expire after a month

[PaulH]

I have a spreadsheet that I'm using to track progress over the period
of a year. One sheet is raw data that is manually entered daily and
one sheet is monthly statistics based on that data. In the statistics
worksheet are cell formulas calculating statistics relating to each
month based on the raw data.

If I change the data in March, I don't want January's or February's
statistics to be changed.

Is there a way to do this?

Thanks,
PaulH

 

[PaulH]

I have a spreadsheet that I'm using to track progress over the period
of a year. One sheet is raw data that is manually entered daily and
one sheet is monthly statistics based on that data. In the statistics
worksheet are cell formulas calculating statistics relating to each
month based on the raw data.

If I change the data in March, I don't want January's or February's
statistics to be changed.

Is there a way to do this?

Thanks,
PaulH

One method of accomplishing this I was considering was to have a macro
that runs when the spreadsheet is opened and checks the date. If it is
March, then it somehow removes the formulas from January and February
and they become static data. Or, perhaps it could lock the data in
those months so that the formulas couldn't change them...

-Paul

 

[Earl Kiosterud]

PaulH,

One manual way would be to, before you enter the March Data, select and copy the February
formulas, then with the same selection, Paste-Special-Values. That will replace the formula
with the current formula results (numbers), which won't change any more as a function of the
data.

Another would be to not have, e.g.: the March formulas, have any references to the prior
data.