Change date in cell when contents of other cell changes

C

chez.sky

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?
 
J

Jon Peltier

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

- Jon
 
Top