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

[steveb1988]

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!

[hafizimran]

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:

Please Login or Register  to view this content.

[steveb1988]

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