title: Log date & time [...] in sheet2, when editing a cell in a specified range in sheet1
body: <p>I have Sheet1 looking like this</p>
  
  <p><a href="https://i.stack.imgur.com/QhFmp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QhFmp.jpg" alt="https://i.imgur.com/4HUV6HI.jpg"></a></p>
  
  <p>running this code:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  Dim WorkRng As Range
  Dim rng As Range
  Dim xOffsetColumn As Integer
  
  Set WorkRng = Intersect(Application.ActiveSheet.Range("B2:K10"), Target)
  xOffsetColumn = 11
  
  If Not WorkRng Is Nothing Then
      Application.EnableEvents = False
      For Each rng In WorkRng
          If Not VBA.IsEmpty(rng.Value) Then
              rng.Offset(0, xOffsetColumn).Value = Now
              rng.Offset(0, xOffsetColumn).NumberFormat = "dd-mm-yyyy, hh:mm:ss"
          Else
              rng.Offset(0, xOffsetColumn).ClearContents
          End If
      Next
      Application.EnableEvents = True
  End If
  End Sub
  </code></pre>
  
  <p>What it does so far:</p>
  
  <ul>
  <li>when I edit anything in range <code>B2:K10</code> it adds the date &amp; time on the right side of the table</li>
  </ul>
  
  <p>What I need:</p>
  
  <ul>
  <li>when I edit anything in the range specified above, log the date &amp; time plus the corresponding step &amp; item, all into <code>Sheet2</code> starting from <code>A2</code></li>
  </ul>
  
  <p>Expected result:</p>
  
  <p><a href="https://i.stack.imgur.com/wcEXH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wcEXH.jpg" alt="https://i.imgur.com/0gpNbhi.jpg"></a></p>
  
  <p>And keep adding below last row over and over, never erase a record if a value is deleted from a cell in <code>Sheet1</code>. Will delete records manually if needed.</p>