Multiple users - formula to record who entered a value in a cell

[Spoursy]

I use 365 and have a number of users coauthoring a workbook. When they make any change to a cell (either an initial entry, update or choice from a validation) is there a way of automatically recording into another cell the name of the person that made that change? 8 know I can look at a list of changes from a link in the ribbon but would like to see the name as described above. Any help welcome!

 

[Legacy 143009]

It's impossible without vba. Even if you use a function, it will update the username with the user who is currently using the file.

 

[Spoursy]

Thanks. Do you know a VBA that would track all changes made in a specific sheet?

 

[Legacy 143009]

Right click to sheet tab. Select "View Code". Paste the code below to the new opened window. This code will log the changes in column Z:

Private Sub Worksheet_Change(ByVal Target As Range)
  With Application
  .EnableEvents = False
  Cells(Rows.Count, "Z").End(xlUp).Offset(1).Value = .UserName & " has modified cell: " & Target.Address
  .EnableEvents = True
  End With
End Sub

 

[Spoursy]

Ive tried to do that but when I try and run it the pop up Macro box comes up asking for a name

 

[Legacy 143009]

No, you don't run it. This is an event, which means, it will fire up automatically each time a change occures in the sheet.

 

[Spoursy]

No, you don't run it. This is an event, which means, it will fire up automatically each time a change occures in the sheet.

Thanks - Can you let me know how I could get it to record the changes made in a specific sheet called "OSV Tracker".

 

[Legacy 143009]

Private Sub Worksheet_Change(ByVal Target As Range)
  With Application
   If .UserName = "OSV" Then
    .EnableEvents = False
    Cells(Rows.Count, "Z").End(xlUp).Offset(1).Value = "OSV has modified cell: " & Target.Address
    .EnableEvents = True
  End If
  End With
End Sub

 

[Spoursy]

Should the userName. be "OSV Tracker"?

 

[Legacy 143009]

Should the userName. be "OSV Tracker"?

Yess, Sorry my mistake. You can customize it according to username you need.