Automatically move row of data in table from one worksheet to another

Hi everyone, help desperately needed - new to excel!

I have a workbook with two sheets - one active and the other complete. I have a table which lists projects which I would like excel to automatically 'archive' when I type in the complete date, deleting it from the first worksheet.

I have followed all the other steps on another post and watched countless YouTube videos and just can't get it to work. I have attached a copy of the workbook in the hope someone can help me as I can't work out what I'm doing wrong!

Thanks in advance!

First of all, on both sheets, convert your tables to Range.
then Right Click on the sheet tab (Active) and click View code.
Paste this code into code window:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 8 Then 'H column
        If Target.Text = "" Then Exit Sub
        
        Dim lngCompleteLastRow As Long
        
        lngCompleteLastRow = Sheets("Complete").Cells(Rows.Count, 2).End(xlUp).Row
        
        
        Target.EntireRow.Copy Sheets("Complete").Cells(lngCompleteLastRow + 1, 1)
        Target.EntireRow.ClearContents
        
        'If you want to delete the row instead, uncomment the following line of code
        'Target.EntireRow.Delete
        
    End If
End Sub

Excellent, thank you SO much - especially for providing a copy 'already made earlier'! Really do appreciate your time in responding.