date last updated
Hello
Is there a way to show on the excel worksheet when it was last updated.
i.e. not when it was just last saved but when the data was actually modified
whether it be via a link or manually inputted. i know the time will change
every time any cell is selected but i need it to remember when a cell is
altered, ive tried using a circular reference but this only shows the time
that the data was origionally inputted i.e.
=IF(CF3="","",IF(CH3="",TODAY(),CH3))
any ideas
Regards
Hoyt
|