View Single Post
  #1   Report Post  
CC
 
Posts: n/a
Default change automatically a value when another cell value changes

I keep a list of students and activities. Because the number of students per
activity is limited, I would to track the date and time when they selected
their activity:
Student Activity Date
--------- -------- -----------
Smith Tennis 02/01/05

I would like the cells in the Date column to change automatically when the
Activity value is changed.
Thanks a lot,