title: Create a new datestamp every time a certain cell changes?
body: <p>I have a cell that states the status of a project, and this status will change frequently. </p>
  
  <p>Whenever the status gets changed, I would like a row to state the time the status was changed and the name of the new status. </p>
  
  <p>I have next to no experience with VBA, so any assistance would be greatly appreciated. So far I have this:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Target.Column = 4 And Target.Row = 4 Then
  
          Target.Offset(10, 3) = Format(Now(), "YYYY-MM-DD HH:MM:SS")
  
      End If
  
  End Sub
  </code></pre>
  
  <p>This code successfully lists the time in cell G7 whenever the status contained in cell D4 changes, but it always repopulates the same cell, I would like each successive status change to list the date stamp in cell G8, then G9, then G10, and so on. </p>
  
  <p>It also doesn't list what the status cell D4 is changed too, ideally I would like that to be listed in F7, then F8, then F9, and so on.</p>