Change date in cell when contents of other cell changes
 

I have a tracker with 100's of entries. I have a status column and a
date the status last changed. I want to be able to automatically
update the date the status last changed when the status changes. Other
solutions on here relate to specific cells changing, but I have 100's
of cells to listen on and related destination cells.

Any ideas?

Change date in cell when contents of other cell changes
 

Extend the Worksheet_Change approach to refer to a specific range, which
contains the changing cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
I have a tracker with 100's of entries. I have a status column and a
date the status last changed. I want to be able to automatically
update the date the status last changed when the status changes. Other
solutions on here relate to specific cells changing, but I have 100's
of cells to listen on and related destination cells.

Any ideas?