Is there any way to have a cell Time/Date stamp on an event?

[Guest]

I'd like to have a cell time stamp on a certain event, such as the filling of
another cell.

Any ideas on that?

 

[Frank Kabel]

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

 

[Myrna Larson]

You need to use a Worksheet_Change event macro for this. You should find
plenty of examples on Google.

 

[bsullins]

A more manual way of doing this would be to make a formula for it, the
do a copy paste values over the cells with the timestamp.

ex:

if(a1="","",now())

This will enter a timestamp if cell 'a1' contains any value.

Simple, but effective in a world where macros are shun..