One way is to use datafilterautofilterfilter on completecopy/paste to
newdeleteunfilter. Record a macro while doing.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RA" wrote in message
...
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.