Option Base 1
Sub test()
Dim Tabl1 As Variant, Tabl2 As Variant, Tabl3(), I As Long, J As Long
Dim Teste As Boolean, Ctr As Long
Tabl1 = Range("B2", Cells(Rows.Count, 5).End(xlUp))
Tabl2 = Application.Transpose(Range("H2", Cells(Rows.Count, 8).End(xlUp)))
For I = 1 To UBound(Tabl1, 1)
Teste = False
For J = 1 To UBound(Tabl2)
If Tabl1(I, 1) = Tabl2(J) Then
Teste = True
Exit For
End If
Next J
If Teste = False Then
Ctr = Ctr + 1
ReDim Preserve Tabl3(4, Ctr)
Tabl3(1, Ctr) = Tabl1(I, 1)
Tabl3(2, Ctr) = Tabl1(I, 2)
Tabl3(3, Ctr) = Tabl1(I, 3)
Tabl3(4, Ctr) = Tabl1(I, 4)
End If
Next I
Range("B2", Cells(Rows.Count, 5).End(xlUp)) = ""
[B2].Resize(UBound(Tabl3, 2), UBound(Tabl3, 1)) = Application.Transpose(Tabl3)
End Sub