automatically update a field only when data has changed
 

I have a worksheet that users will sometimes update data in, other times not.
I have a field that uses the =TODAY() function that I'd like to have updated
ONLY if the data in the worksheet has changed and been saved. Is this
possible?

automatically update a field only when data has changed
 

Look he

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bigdog2112" wrote in message
...
I have a worksheet that users will sometimes update data in, other times
not.
I have a field that uses the =TODAY() function that I'd like to have
updated
ONLY if the data in the worksheet has changed and been saved. Is this
possible?