Move the prefered row from one sheet to another

I need to provide list of priority to two or more machines in one worksheet. Once the status is "Completed", then the particular row values has to move to next worksheet in a list. Before moving it should ask for a pop up message. Can someone help with a macro.
attached is the sample file.

What would the pup up message be? And what action would be taken if Yes is seleceted and what action if Cancle is selected?

If in the pop up message i hit "Yes" then it has to be moved, and if hit "No" then clear the cell content "completed".

So give me one more answer.
When you insert Completed should the macro check if the Part No is already on sheet 2 and then not copy it?
Or should it check if the WO number is already there and if it is then not copy the info to sheet 2?

Anyway try this then:

Do you mean like this:

Please Login or Register  to view this content.

No...That just clears the content
He wants it so when say in cell I10 he writes "Completed" then the msgbox is poped up and askes if you want it copyed or not.
The action in my workbook is taken when he writes "Completed" say in range I10 and presses enter and then moves back to I10 from I11.
Can't the macro run when you enter Completed in a cell in range I10 and hit enter? So you don't have to move back to the cell you just entered Completed in?
Hope you know what I mean

Hope this helps...
Instead of MsgBox "Do something" you can write your code

Please Login or Register  to view this content.

Its not necessary to check whether the list is there in sheet2. As there are chances the same part no: and wo no: can repeat.
I need to also include the M/c no: in sheet 2 according to the data in sheet1.

sreejeshc...
Well this now does what you wanted....but when you insert Completed then press enter and press up so you move back to the cell where you inserted Completed.
And don't know how to make it work when you write Completed and hit enter

Thanks Guys.........

Hi Stojko89,

Can i get the copied rows in sheet"c" as paste special values only