I have this code that is working perfectly. When any row in column 14 becomes "Closed" The entire row is cut and pasted into the "Closed" worksheet. What I am trying to figure out is how to make the date and user get inserted in column 15 and the corresponding row to the "Closed" event. Any help would be greatly appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)

 Application.EnableEvents = False

  If Target.Column = 14 Then

   If Target = "Closed" Then

            
     nxtRw = Sheets("Closed").Range("A" & Rows.Count).End(xlUp).Row + 1
             
      Target.EntireRow.Copy Destination:=Sheets("Closed").Range("A" & nxtRw)

      Target.EntireRow.Delete shift:=xlUp
   End If
  End If

 Application.EnableEvents = True
 

End Sub