Cut and Paste Rows from one worksheet to another based on criteria in two columns

I’ve found a number of posts on this subject but can’t seem to find one that quite works for me.
I have a workbook with two worksheets.( Started, Completed) In worksheet “Started” if column F has any data (anything other than blank) and column H contains anything other than “Transfer Accepted”,
I need to cut and paste these rows into worksheet “Completed” and delete the empty row in “Started”.
(the data in the two columns may not coincide to meet the criteria)

Thanks for any help!

Please Login or Register  to view this content.

Originally Posted by jraj1106

Hi.

Try this:

Attachment 213054

Thanks, works great for half of it. I also need to move column H if it contains anything other than “Transfer Accepted”,

Thanks for the help!

Thanks AB33 and jraj1106. I've tried all the codes including the last from J. But Column H is still Not moving. I've attached my results

Correct. These are the resluts from the code I have tried. Column H however still contains data other than "transfer accepted"

Are these criteria,
Column F is not blank NOT column H is not "transfer accepted"
or
Column F is not blank OR column H is not "transfer accepted" ?
The code for both is not the same. Please clarifay

Column F is not" blank" AND column H is not "transfer accepted"

Well, I do not see what is wrong with the code I provided then? For e.g in Rows 2, 4 and 6, Column F is not blank(Has value-letters) and column H is not "Transfer Accepted", so these rows will move over.

Thanks for your time. I apologize if I am not explaining this properly. I attached a workbook with your code. These are the results I'm getting after I run the code. Column H still has data other than "Transfer Accepted"

Please see attached.
I have two codes with two different results. I suspect, your request was code 2 which is OR, not NOT. Let me know

Perfect! Thank you so much for your time and patients.

You are welcome!
Please close this thread now as solved. Go in to the top right-hand side of the page, choose "Thread Tools" ,select solved from the drop down menu

You are welcome!
Please close this thread now as solved. Go in to the top right-hand side of the page, choose "Thread Tools" ,select solved from the drop down menu