Thread: automatically update a field only when data has changed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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?

Reply With QuoteReply With Quote