Private Sub CommandButton1_Click()
Dim ar1, ar2, re, y%, x%, mm%
Dim i As Integer, j As Integer, m As Integer, r As Integer
ar1 = Range(Cells(1, 1), Cells(4, 15))
ar2 = Sheets(2).Range(Sheets(2).Cells(1, 1), Sheets(2).Cells(8, 15))
ReDim re(1 To UBound(ar2), 1 To 15)
r = 0
For mm = 1 To UBound(ar2)
For x = 1 To UBound(ar1)
m = 0
For i = 1 To 15
If ar1(x, i) = ar2(mm, i) And ar2(mm, i) <> "" Then
m = m + 1
End If
Next i
If m > 5 Then Exit For
Next x
If x > UBound(ar1) Then
r = r + 1
For j = 1 To 15
re(r, j) = ar2(mm, j)
Next j
End If
Next mm
If r > 0 Then Sheets(2).Cells(1, 18).Resize(r, 15) = re
End Sub