thanks. manual won't work, because I will not be the one using it and I would
have to do it manually for every field. I could just type it in as fast. I
have experimented with the IF function and could use it, if someone knows how
to make it so that the cell's value does not change the if the condition is
not true.

"CLR" wrote:

To do it manually......
Copy PasteSpecial Values

Vaya con Dios,
Chuck, CABGx3


"TomH" wrote:

I appreciate the info. If I cannot find any other way to do it, I will make
that work. I would rather do it all with one file, if possible. I guess my
real question is: Is there any way to save data into a seperate cell before
the data changes?

"CLR" wrote:

Perhaps you could just Archive the file occasionallly, by doing a File
SaveAs ....and using a different name with a date code..........then you
could retrieve the data you need from any one of them.

Vaya con Dios,
Chuck, CABGx3



"TomH" wrote:

I have a payroll speadsheet. It works well, but I would like to keep
year-to-date totals. My problem is that my weekly totals are not static (they
come from a formula). The weekly totals change every week but I cannot figure
out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks