Moving Entire row from one sheet to another

sidmdhar - Oct 9, 2016 at 07:10 AM
I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status could be 'pending, ongoing, under-observation, completed.'
I wish to move all completed jobs from sheet 1, to sheet 2 (completed jobs sheet) automatically.

How may i achieve that? Let me know if you need anymore details.

Please help.

Yearly evaluation due next week. :)