Capture a cell value at the end of day.

[Gared]

I have a workbook with multiple sheets that calculates the daily production
in my shop. How do I get the cell to equal itself at the end of the day
keeping the total. I use a 3-D sum function on the last sheet to calculate
the dialy production then I use a IF statement like =IF(A10=TODAY(),
SUM(Template:Summary!$J$1),"") where columb A is a list of sequential days.
My problem is if the statement is false I lose yesterdays total and these are
the numbers I need to keep. How do I get the cell to equal itself before the
date changes to tommorow.

I hope this is understandable!!!

 

[Frank Kabel]

Hi
if I understood this correctly it can't be done with formulas alone.
This would require VBA