Thread: How to set current day when a cell in a colum change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steen Steen is offline
external usenet poster
  
Posts: 104
Default How to set current day when a cell in a colum change
I wold like some help on the below matter:

ID Status ChangeDate Resp.
---------------------------------------------
1 Closed 2006-06-01 XXXX
2 New 2006-06-20 YYYY
3 Working 2006-07-01 XXXX

Every time Status is change I would like to have ChangeDate to be updated
current date and Resp. with the Name/initials of the person editing the Excel
Sheet - any suggestions?
Reply With QuoteReply With Quote