How to select and copy rows of data that contain a certain text w/t Macro?

[lsn11]

Hello,

I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into another sheet (Sheet 2 - "Complete") without overwriting the rows in sheet 2. And Finally Deleting the copied "Completed" rows from sheet one.

I am having trouble finding a select row by certain text feature to start the macro with.

PLEASE HELP!

Text Word "Completed"
Sheet one name - "All PO'S"
Sheet two name - "Completed"

 

[JLGWhiz]

Do you have formulas in the cells of sheet 1? If so, could you post an example of one.