title: Excel - Update Column with Date Time when Another Cell is First Changed
body: <p>I would like my Excel spreadsheet Column B to be stamped with a date time only when Column A first changes.  I have seen a lot of VBA code but it captures the last change, not the first change.</p>
  
  <p>I tried to use this:  </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Column = 1 And Target.Offset(0, 1).Value = "" Then
          Target.Offset(0, 1) = Format(Now(), "HH:MM:SS")
      End If
  End Sub
  </code></pre>
  
  <p>It worked except when I copy and paste into say 3 rows, the date time stamp only shows up for the first of 3 records.</p>