Post your formula.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"NTaylor" wrote in message
...
I have a worksheet that automatically updates everyday and works some
calculations for me. How can I get the formula sheet to keep the value from
the previous day if there is no data today. Because now it is filling in
all
my cells with zeros. Thanks
--
Nicki Taylor