MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding the PREVIOUS value of a changed cell

Posted by Parit on May 14, 2001 10:01 AM

Is there anyway to know what the value of a cell WAS before it was changed? (i.e. previous value).

The only thing I have found is to keep an exact duplicate of the worksheet, and compare the changed cell with the older worksheet.

There has to be a more efficient way to determine the previous value of a changed cell.

Any help on this would be greatly appreciated.


Posted by Mark W. on May 14, 2001 10:18 AM

You could "share" a workbook and in doing so turn
on "tracking". Take a look at the Excel Help topic
for "shared workbooks, change history".