View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DAKent DAKent is offline
external usenet poster
 
Posts: 2
Default Update Date Cell when any of target cells change

I have a row of user entered data (B-AP7) and a date cell (A7). I would like
to update A7 with the current date any time one or more cells in B7-AP7
changes. If there is no change, A7 stays constant. I would like to repeat
this functionality for the next 99 rows.

Basically, I want to know the when was the most recent update for each row
of data in a worksheet.

I appreciate any assistance.