AW: zwei Spalten vergleichen
04.01.2024 00:23:10
Piet
Hallo
ich nehme an den Code bekommst du in deine Datei kopiert. Damit sollte es gehen.
mfg Piet
Sub IDNummern_vergleichen()
Dim AC As Range, AJ As Range
Dim Txt As String, z3 As Long
Dim Tb1 As Worksheet, lz1 As Long
Dim Tb2 As Worksheet, lz2 As Long
Set Tb1 = Worksheets("Tabelle1")
Set Tb2 = Worksheets("Tabelle2")
With ThisWorkbook.Sheets("Tabelle3")
.Range("A:B").ClearContents
'LastZell in Spalte A suchen
lz1 = Tb1.Cells(Rows.Count, 8).End(xlUp).Row
lz2 = Tb2.Cells(Rows.Count, 4).End(xlUp).Row
For Each AC In Tb1.Range("H1:H" & lz1)
Txt = Empty
For Each AJ In Tb2.Range("D1:D" & lz2)
If AC.Value = AJ.Value Then Txt = "Ok": Exit For
Next AJ
If Txt = Empty Then
z3 = z3 + 1
.Cells(z3, 1) = AC.Value
.Cells(z3, 2) = Tb1.Name
End If
Next AC
For Each AC In Tb2.Range("D1:D" & lz1)
Txt = Empty
For Each AJ In Tb1.Range("H1:H" & lz2)
If AC.Value = AJ.Value Then Txt = "Ok": Exit For
Next AJ
If Txt = Empty Then
z3 = z3 + 1
.Cells(z3, 1) = AC.Value
.Cells(z3, 2) = Tb2.Name
End If
Next AC
End With
End Sub