Sub CopyRow()
'Declare variables
    Dim sheetNo1 As Worksheet
    Dim sheetNo2 As Worksheet
    Dim FinalRow As Long
    Dim Cell As Range
    
'Set variables
    Set sheetNo1 = Sheets("EA Log")
    Set sheetNo2 = Sheets("Commitments")
' Define destination sheets to move row
    FinalRow1 = sheetNo2.Range("A4:A" & sheetNo2.Rows.Count).End(xlUp).Row
'Apply loop for column P until last cell with value
    For Each Cell In sheetNo1.Range("P4:P" & sheetNo1.Cells(sheetNo1.Rows.Count, "P").End(xlUp).Row)
'Apply condition to match the "Signed" value
        If Cell.Value = "Signed" Then
'Command to Copy and move to a destination Sheet "Commitments"
            sheetNo1.Range(Cells(Cell.Row, 2), Cells(Cell.Row, 3)).Copy _
                        Destination:=sheetNo2.Range("A4:A" & FinalRow1 + 1)
                        
            sheetNo1.Range(Cells(Cell.Row, 14), Cells(Cell.Row, 25)).Copy _
                        Destination:=sheetNo2.Range("C4:C" & FinalRow1 + 1)
                        
            sheetNo1.Range(Cells(Cell.Row, 1)).Copy _
                        Destination:=sheetNo2.Range("E4:E" & FinalRow1 + 1)
                        
            FinalRow1 = FinalRow1 + 1
        End If
    Next Cell
End Sub
            Asked
            
        
        
            Active
            
        
            Viewed 26 times
        
    0
            
            
         
    
    
        Warcupine
        
- 4,460
- 3
- 15
- 24
- 
                    Bitten by `Range(Cells(), Cells())`. – BigBen Aug 18 '22 at 14:53
- 
                    Not too sure what you mean by that BigBen, can you please specify. thanks – johngreenough Aug 18 '22 at 14:57
- 
                    Did you read the linked threads yet? It's specified quite well in them. – BigBen Aug 18 '22 at 14:58
