2,462
社区成员
发帖
与我相关
我的任务
分享
Sub 筛选()
Dim sh As Worksheet, sr As String
Dim outArr(), tempArr(), index As Long, i As Long, j As Long
Sheet2.Range("a2:e99999").Clear
ReDim outArr(1 To 99998, 1 To 5)
index = 1
sr = InputBox("Input Keyword")
For Each sh In Worksheets
If sh.Name <> "查询" Then
tempArr = sh.Range("A2:E" & sh.Cells(Rows.Count, 1).End(xlUp).Row).Value
For i = LBound(tempArr) To UBound(tempArr)
If tempArr(i, 2) Like sr Then
For j = 1 To 5
outArr(index, j) = tempArr(i, j)
Next j
index = index + 1
End If
Next i
End If
Next sh
Sheet2.Range("a2:e99999").Value = outArr
End Sub