Track Changes - User / Time / Date
 

We have a spreadsheet that is shared between several users. It is used to
track specific calls that come in.

Every time a call comes in, the user goes into the spreadsheet and enters on
the next available line some of the customer information (i.e. name, address,
issue, etc). I would like to have it that every time the user starts a new
entry on a line, that the Username, Time, Date of the change automatically
appear in the first few columns, respectively, of the new row.

I started to make a formula where the user just enters the date and then I
had a "Now" formula that would automatically enter the time, but obviously,
that "Now" time would change every time the workbook is opened.

Any ideas? I have a feeling this will be more of a programming issue (which
is fine), just hoping for something to make this spreadsheet more fool-proof.
Thanks in advance!

Track Changes - User / Time / Date
 

Hi,

You will need to use VBA.

Here is some sample code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Application.Intersect(Target, Range("A1:A100"))
If Not isect Is Nothing Then
Cells(Target.Row, 2) = Date
Cells(Target.Row, 3) = Time
Cells(Target.Row, 4) = Application.UserName
End If
End Sub

1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find your sheet name under your
file name and double click it.
3. Paste in or type the code above.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Keep It Simple Stupid" wrote:

We have a spreadsheet that is shared between several users. It is used to
track specific calls that come in.

Every time a call comes in, the user goes into the spreadsheet and enters on
the next available line some of the customer information (i.e. name, address,
issue, etc). I would like to have it that every time the user starts a new
entry on a line, that the Username, Time, Date of the change automatically
appear in the first few columns, respectively, of the new row.

I started to make a formula where the user just enters the date and then I
had a "Now" formula that would automatically enter the time, but obviously,
that "Now" time would change every time the workbook is opened.

Any ideas? I have a feeling this will be more of a programming issue (which
is fine), just hoping for something to make this spreadsheet more fool-proof.
Thanks in advance!