View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] chez.sky@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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?