Hi All,
I'm trying (unsuccessfully!) to write a macro which will move completed jobs from 8 different department job list worksheets to a completed jobs worksheet.

As mentioned I have 8 different departments each with their own job worksheet. In column K I have status. When the status is complete I would like to move the completed rows to the next available space in the 9th worksheet (completed works). I would like the rows to be removed completely from the job worksheets. For info the top row of all of the worksheet contains the same headers.

If anyone can help I'd be enormously grateful.