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.