View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kanmi Kanmi is offline
external usenet poster
 
Posts: 76
Default Automatic Date Aupdate

I want to set row above that automatic change date when i change data on each
of the column. For example

Last Update: 6/14/2009 5/19/2009 5/19/2009
(2) 3 4
4 5 6
I want if i change 2 to 100 then 6/14/2009 should change to that
modification day date automatically. If i change it today then 6/14/2009 will
change to 06/23/2009

Meaning this will be modification date. please can anybody help me with
this. Appreciate your time. Thanks.