Cell formulas that expire after a month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PaulH - 07 Mar 2008 17:52 GMT

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

Reply to this Message

PaulH - 07 Mar 2008 17:55 GMT

> 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
[quoted text clipped - 9 lines]
> 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

Reply to this Message

Earl Kiosterud - 07 Mar 2008 19:06 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>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
[quoted text clipped - 9 lines]
> Thanks,
> PaulH

Reply to this Message

Rate this thread: