need a macro

[JasonLeVan]

I need a macro to compare columns c and d if they are not the same i need it to copy that row to sheet2 starting row 5. thanks

 

[VoG]

Try

Sub CopyRows()
Dim LR As Long, LR2 As Long, i As Long
LR = Range("C" & Rows.Count).End(xlUp).Row
For i = 1 To LR
    If Range("C" & i).Value <> Range("D" & i).Value Then
        LR2 = WorksheetFunction.Min(5, Sheets("Sheet2").Range("C" & Rows.Count).End(xlUp).Row + 1)
        Rows(i).Copy Destination:=Sheets("Sheet2").Range("A" & LR2)
    End If
Next i
End Sub

 

[Trevor G]

Try this out first.

Place in a cell the formula countif and select the first cell in the first column and then the whole of the second column in the next step of the formula, then fill going down, this will give you a number and if only 1 then add a filter to show only 1 then you can copy the rows or cells.

If this works then you can record a macro to do most of this automatically.