Thread: Change date in cell when contents of other cell changes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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?



Reply With QuoteReply With Quote