Moving Entire row from one sheet to another [Closed]

Report
-
Hey,
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. :)


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!