How do I get one cell to record the time another cell was changed.
 

I know there's a simple solution to this, but I'm not seeing it. How can I
set up a cell to update the time (or date) whenever another cell has data
entered into it; e.g. cell A1 has new info entered into it, and cell A2
automatically updates the time of that update. Thanks in advance.

One way

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

Regards,

Peo Sjoblom


"Reigning in Seattle" wrote:

I know there's a simple solution to this, but I'm not seeing it. How can I
set up a cell to update the time (or date) whenever another cell has data
entered into it; e.g. cell A1 has new info entered into it, and cell A2
automatically updates the time of that update. Thanks in advance.