Cut and Paste Rows when conditions are met

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.

Hi synflame,

please provide example workbook sheet then its more easy to solve ur query.

Thanks - Naveed.

Current Worklist 2012.xlsx

Hi Naveed,

Thanks for the reply. Here is an example workbook.

Best regards,
Synflame

Hi,

Note: Its totally Automated once the cell changed to "Completed" it will moved to Completed works tab and make sure that completed should written in this way Completed and one more thing each and every tab contain VBA Macro so if u add any New tab in this workbook then goto VBScript page and copy the Code from any tab and paste in particular sheet ok.

Please find the attached workbook and have review and let me know if u have any question.

Thanks - Naveed.