Date, time and user stamp if cells updated

**samcdavies** · 04-25-2013, 02:47 PM

I have some information in 3 cells - here is an example;

A1=StartDate, A2=EndDate, A3=Days

If ANY of these 3 cells are changed I would like A4 to update with the current date and time and A5 to update with the current user. I will then extend this out to work on all rows [I have about 20 rows of info like this].

On top of this, if any of those 3 cells are changed again, I would like cell A6 to update with the current date and time and A7 to update with the current user.

This would create a log on when the info was created and when it was last updated.

Is this possible?

Thanks in advance,
Sam

**samcdavies** · 04-27-2013, 07:50 AM

I see there are no bites on this one. If we exclude the second part of the problem for now. Is it possible to just do the first part, which is;

I have some information in 3 cells - here is an example;

A1=StartDate, A2=EndDate, A3=Days

If ANY of these 3 cells are changed I would like A4 to update with the current date and time and A5 to update with the current user. I will then extend this out to work on all rows [I have about 20 rows of info like this].

I'm guessing this will be a VBA code?

I'd really appreciate any help offered.
Thanks,
Sam

**HaHoBe** · 04-27-2013, 08:02 AM

Hi, Sam,

right-click on the worksheet tab, choose View Code and paste the code into the code window:

Please Login or Register  to view this content.

Any manual change or entry in Columns A to C on that sheet will trigger the event if macros are enabled and will start reporting as you want (no error handling for reaching the last column here

).

Ciao,
Holger