View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carole O Carole O is offline
external usenet poster
 
Posts: 69
Default Update date field upon cell range change

Excel 2003
I have a shared spreadsheet and the users can change any cell between
A4:K100. The date is in A3. I'm looking for code which would put today's
date in A3 when any cell in A4:K100 is changed. If someone opens the report,
but does not change it, the date does not change. That way, when the users
prepare for a meeting, they know if they have the latest report. I checked
out Timestamp, but didn't find what would suit this need.

TIA,
Carole O