If the answers to my question are true try this:
If sheet name is not correct modify my script
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
The script runs when you enter any value into column G
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 5/9/2022 6:12:41 PM EDT
If Target.Column = 7 Then
Application.EnableEvents = False
Dim Lastrow As Long
Lastrow = Sheets("Archive").Cells(Rows.Count, "G").End(xlUp).Row + 1
Rows(Target.Row).Copy Sheets("Archive").Rows(Lastrow)
Rows(Target.Row).Delete
Application.EnableEvents = True
End If
End Sub