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!