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.

Try JE's page at:

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

Look for "Using a worksheet event macro"
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"A Benn" <%^%^^(E-Mail Removed)> wrote in message
news:415bd6ac$(E-Mail Removed)...
> 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.
>
>