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

On Mar 7, 11:52*am, PaulH <paul.h...@gmail.com> wrote:
> 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

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.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"PaulH" <(E-Mail Removed)> wrote in message
news:01ed363f-8985-4f71-b899-(E-Mail Removed)...
>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