New to macros
 

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.

New to macros
 

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.