Merhaba Ercan Bey,
Kodu bir düğmeye atayıp çalıştırın;
Sub Excelce_Aynilari_Bul_Aktar()
Dim excelce_borc As Range, excelce_alacak As Range
excelce_basla:
For Each excelce_borc In Worksheets("liste").Range("G2:G" & Worksheets("liste").Range("G65530").End(3).Row)
If excelce_borc = 0 Then GoTo excelce_ileri
For Each excelce_alacak In Worksheets("liste").Range("H2:H" & Worksheets("liste").Range("H65530").End(3).Row)
If excelce_borc <> 0 And excelce_borc = excelce_alacak Then
rapor_son = Worksheets("rapor").Range("A65530").End(3).Row + 1
excelce_borc.EntireRow.Cut Worksheets("rapor").Range("A" & rapor_son)
excelce_alacak.EntireRow.Cut Worksheets("rapor").Range("A" & rapor_son + 1)
GoTo excelce_basla
End If
Next excelce_alacak
excelce_ileri:
Next excelce_borc
MsgBox "İşlem tamam.", vbInformation, "Excelce.Net"
End Sub