Help With VBA to Move one Row on one Table to Another Table

[Mista_sav]

I have identical Tables, one is called Active and one is called Completed. They are on separate Sheets, also called Active and Completed.

In column H there is an option to select the status. When someone selects "Complete - No Further Action Required" i would like it to move (then delete) this row from the table and add it to the Completed table.

Any help on a VBA to do this automatically?

 

[Mista_sav]

Yes, doesn't use a filter to copy all the rows with "Complete - No Further Action Required" in the target column - just the row that you have just changed.

champion, tested properly this time and works to perfection! i have marked the above as successful i think?

Cheers again mate, muchly appreciated