Cut the row from a sheet and paste it to another if certain criteria is met

[mhaverk]

Hi fellow forum members,

I am sure this has been covered a number of time but as I am extremely new to macros I cannot get any of the solutions I have found to work.

I have a job tracking spreadsheet which shows the status in Column D. When a job is “Complete” I want to run a macro to move it from the “Current Jobs” to the “Completed Jobs” worksheet.

Can anyone point me in the right direction or assist in anyway.

Thanks in advance,

Michael

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[mhaverk]

See attached sample of what I am trying to achieve.

Hoping it will cut the "Completed" jobs from "Current Jobs" workbook and paste them in the "Completed Jobs" worksheet.

Thanks in advance.

[shyamhappy]

See attached sample of what I am trying to achieve.

Hoping it will cut the "Completed" jobs from "Current Jobs" workbook and paste them in the "Completed Jobs" worksheet.

Thanks in advance.

Just advancement of previous reply.

[mhaverk]

This seems to be taking the last row only and copying it across.

Can I make it cut all rows that have "Completed" in column D and paste them in the other workbook?

Thanks.

[shyamhappy]

Attachment 255698

Above attached file will help you to obtain the objective

[mhaverk]

Thanks thats great.

One last thing, can it delete the "completed" line on the "Current Jobs" after copying it to the "Completed Jobs" workbook?

Thanks so much for you assistance.

[shyamhappy]

Attachment 255739

Here is the macro for the deleting the row and fill entry of Complete job in the Completed Sheet.

_________________________________________________________________________________________
if you feel the help is worth please add to reputation