Formulas

Posted by Jeff Bough on January 07, 2002 10:01 AM

I am looking for a formula that will allow me to change the value of a cell, but also keep all total values that have been entered into that cell in a different cell location. Please Help!!

Posted by Damon Ostrander on January 07, 2002 10:29 AM

Hi Jeff,

Have you looked into change tracking (Tools->Track Changes->Highlight Changes? This keeps track of all manual changes to all cells, and also provides the capability to summarize all the changes on a separate worksheet.

Damon