Copy row to new sheet

[blee4372]

I have a worksheet called "Tracker" & what I am trying to do is...If any date is entered in column M that row is copy to a new worksheet called Completed Orders. Also would like the macro to delete the row from the Tracker sheet.
I would be greatful for any help.

 

[jim may]

Does your Completed Orders worksheet ALREADY have data accumulating in it when you wish to Copy from your Tracker worksheet?

 

[blee4372]

Does your Completed Orders worksheet ALREADY have data accumulating in it when you wish to Copy from your Tracker worksheet?

Yes...I want the row pasted on the next blank row of the "Completed Orders" sheet.