Update Date Cell when any of target cells change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAKent - 11 Sep 2007 17:46 GMT

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.

Reply to this Message

JE McGimpsey - 11 Sep 2007 18:13 GMT

See

http://www.mcgimpsey.com/excel/timestamp.html

> 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
[quoted text clipped - 5 lines]
>
> I appreciate any assistance.

Reply to this Message

DAKent - 11 Sep 2007 19:18 GMT

That is almost exactly what I am looking. Your example shows how to look for
changes in a column range and write the date in the next column. I need to
figure out how to look at a row(s) range (B-AP) and date stamp a change in
the A cell of the same row(s).

Thanks for your help!

> See
>
[quoted text clipped - 9 lines]
> >
> > I appreciate any assistance.

Reply to this Message