方法是笨点,在d4:f4填入条件,1——3个条件均可,- Sub 筛选()
- Dim i, wdrow, fkh, j
- For i = 5 To Sheets.Count
- wdrow = Sheets(i).[b65536].End(xlUp).Row
- fkh = Sheets("查询表").[b65536].End(xlUp).Row + 1
- Sheets(i).Select
- Range("B4:M" & wdrow).Select
- Range("B4:M12").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets( _
- "查询表").Range("D3:F4"), CopyToRange:=Sheets("查询表").Range("B" & fkh & ":M65536"), Unique:=False
- Next i
- For j = Sheets("查询表").[b65536].End(xlUp).Row To 6 Step -1
- If Sheets("查询表").Cells(j, 2).Value = "编号" Then
- Sheets("查询表").Rows(j).Delete
- End If
- Next
- End Sub
复制代码 |