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

B

benngehman

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

Any ideas on that?
 
M

Myrna Larson

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

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..
 
Top