You want to accumulate totals in D. Best approach is to use a new sheet
each day and accumulate values (=sum(Start:End!D1) - your data sheets are
placed between sheet Start and sheet End in the tab order) in a summary
sheet. Next best is to generate the sum with a macro, rather than a
formula. Almost any other approach is guaranteed to be inaccurate.

--
Regards,
Tom Ogilvy

"Jeff" wrote in message
...
Columns a,b,c added for totals in column D
Next day, new numbers are placed in a,b,c. Simple way to have the number
in
D stay put (not change) but give you the new grand total
--
jeff w