View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default I need to keep a changing value

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