What I'd like to do, if possible:

Say the field in column "A" equals "complete"

Then cut entire line and paste it in the next available line of a new
spreadsheet and delete the old line from the original sheet.

This is a project management worksheet. I want to be able to totally remove
an item from the "To Do" sheet and place it on the "Complete" sheet.