title: How can I automatically populate user name and update time when a cell is updated?
body: <p>Say I have a sheet with 4 columns as the following:</p>
  
  <pre><code>value1 | value2 | updated by | update time
  abc    |        | Employee1  | 18/12/2014 18:13
         | xyz    | Employee2  | 18/12/2014 18:13
  </code></pre>
  
  <p>I want the columns "updated by" and "update time" to be automatically updated if any of the cells in Value1 or Value2 has been updated.</p>
  
  <p>The column updated by takes the name of the user that made the change, it can be the Windows user name or Excel username.</p>
  
  <p>The column update time takes the time when any of the cells value1 or value2 has been updated.</p>
  
  <p>I have no VBA knowledge; is there any way how to achieve this result? I have been searching online, I found out how to populate the update time column via a VBA procedure but the result is not exactly what is expected, and couldn't find how to pouplate the Updated By column.</p>
  
  <p>The VBA code I found online to populate the time is the following:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range) 
      If Not Intersect(Target, Range("A2:A100")) Is Nothing Then 
          Target(1, 4) = Now 
          Target(1, 4).EntireColumn.AutoFit 
      End If 
  End Sub 
  </code></pre>
  
  <p>source: <a href="http://www.ozgrid.com/forum/showthread.php?t=24219" rel="nofollow">http://www.ozgrid.com/forum/showthread.php?t=24219</a></p>