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.
|