Move row to another worksheet based on cell value

Put this code into the module for the sheet called Orders;

Please Login or Register  to view this content.

To paste the code in a sheet module;
1) Right click the sheet tab name, "Orders"
2) Then click "View Code"
3) Paste this code in the large white section on the right
4) Press Alt & Q to exit the VB editor
5) Save the file as a macro enabled file

Every time the word "Complete" is typed into a row within Column N, the entire row will be copied to the next row on the sheet called, "Complete"

Enjoy!