View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keng Kiat
 
Posts: n/a
Default Tracking of changes automatically

Supposed I have a table with a list of Names in column-A, followed by the
respective Status in column-B, how can I have column-C to automatically show
the Date I change the values in a single value of column-B? I tried using
code, but that doesn't allow me to Ctrl-Z to return to previous values in
both columns, in case of typo.

Example
If I change B2 value, how can C2 reflect the date of change in B2?