detecting change

[A Benn]

How can I make a cell automatically log when another cell was updated or a
value entered ?

I can use the NOW() function to log the time when something was first
entered, but then whenever another cell is changed, all the previous cells
with a now() function update.

 

[Max]

Try JE's page at:

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

Look for "Using a worksheet event macro"