79672404

Date: 2025-06-19 17:07:20
Score: 1
Natty:
Report link

You code will work if linked to the Worksheet_Change event of the worksheet.

Const numRowHeader = 1
Const numColStatus = 3
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column <> numColStatus Or Target.Rows.Count > 1 Then Exit Sub

    If Target.Value = "close" Then
        Me.Rows(Target.Row).Cut
        Me.Rows(1).Offset(numRowHeader).Insert
    End If
End Sub

Before update:

Worksheet and VBE picture showing code above and before state of the worksheet

After update:

Worksheet picture showing row 6 was cut and moved to row 2.

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: usncahill