|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Update Date Cell when any of target cells change
See
http://www.mcgimpsey.com/excel/timestamp.html
In article ,
DAKent wrote:
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.
|