Sub 筛选()
Dim arr
Dim arr1
Dim i As Variant
Dim Myr As Variant
Dim j As Variant
Dim ii As Variant
Application.ScreenUpdating = False
Myr = Sheet4.[a65536].End(xlUp).Row
arr1 = Sheet4.Range("A1:CB1")
arr = Sheet4.Range("A6:CB" & Myr)
For i = 1 To UBound(arr)
For j = 1 To 80
For ii = 1 To 1
If arr(i, j) = arr1(ii, j) Then
Cells(i + 5, 1).EntireRow.Hidden = True
GoTo 100
End If
Next
Next
100:
Next
Application.ScreenUpdating = True
End Sub