16组:libenwen2011 (UID: 514207)
Sub 筛选()
Dim arr(), ar(), k, x, j, I, Y, z, xx
z = 5
I = Sheets("查询").Range("B2")
ar = Array(0, "A店", "B店", "C店")
Range("a5:d17") = " "
For Y = 1 To 3
j = 1
Sheets(ar(Y)).Select
k = Application.CountIf(Sheets(ar(Y)).[B:B], I)
ReDim arr(1 To k, 1 To 2)
For x = 2 To Range("b65536").End(xlUp).Row
If Cells(x, 2) = I Then
arr(j, 1) = Cells(x, 1)
arr(j, 2) = Cells(x, 3)
Sheets("查询").Cells(z, 1) = ar(Y)
Sheets("查询").Cells(z, 2) = arr(j, 1)
Sheets("查询").Cells(z, 3) = I
Sheets("查询").Cells(z, 4) = arr(j, 2)
j = j + 1
z = z + 1
End If
Next x
Next Y
Sheets("查询").Select
End Sub
|