J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

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

J.P. wrote:

I have two columns: A and B. Column A is a text summary. Column B is a date
field. Each time I make any change to a cell in column A, I would like the
corresponding cell in column B to update with today's date, thus showing when
the most recent change was made. Any help would be appreciated.
--
J.P.

--

Dave Peterson