View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chongcc chongcc is offline
external usenet poster
 
Posts: 3
Default Update a date cell when a target cell change....

I am try to automatic update a date cell when the target cell changes.
A1 is what I need, A2 is what I had, A3 is the inventory date. I want to
made it whenever A2 change, A3 will automatic update to the current date. If
not, A3 should stay unchange with the last inventory date.

Thanks in advance for your help.