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

[GatorsBucs]

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!

[jraj1106]

Hi.

Try this:

Transfer.xlsm

[GatorsBucs]

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!

[AB33]

Sub CombineAllSheets()

 Dim ms As Worksheet, LRms As Long, sh As Worksheet, LR As Long, i As Long
 
    Application.ScreenUpdating = 0
    Application.DisplayAlerts = 0
    
    On Error Resume Next
    
    Set ms = Sheets("Completed")
  
    With Sheets("Started")
            LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
            
        For i = 2 To LR
           
             If Trim(.Cells(i, "F").Value) <> vbNullString Then
                If Trim(.Cells(i, "H").Value) <> "Transfer Accepted" Then
                .Rows(i).Cut ms.Cells(Rows.Count, 1).End(xlUp).Offset(1)
                End If
             End If
        Next i
             
    End With
      
     Application.CutCopyMode = 0
     
     Application.ScreenUpdating = 1
    
     Application.DisplayAlerts = 1
End Sub

[GatorsBucs]

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

[AB33]

"In worksheet “Started” if column F has any data (anything other than blank)"


On the attached, column F is blank, so the code will not find any non blank Column F.
Are the condition both, or one of them, because the code will be different if it is the latter

[GatorsBucs]

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

[AB33]

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

[GatorsBucs]

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

[AB33]

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.

[GatorsBucs]

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"

[AB33]

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

[GatorsBucs]

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

[AB33]

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

[AB33]

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