麻烦您帮助修改一下代码吧
谢谢
Sub 查询2()
Dim rng As Range
[a5:d65536].Clear
hh = 4
For Each st In Sheets
If st.Name <> ActiveSheet.Name Then
'If sh = "表一" Or sh = "表二" Then
st.Range("A1:e65536").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheet3.Range("A1:e2"), CopyToRange:=ActiveSheet.Range("A" & hh, "e" & hh), Unique:=False
If hh > 4 Then
ActiveSheet.Rows(hh).Delete Shift:=xlUp
End If
Set rng = ActiveSheet.Range("A65536").End(xlUp)
hh = rng.Row + 1
End If
Next st
End Sub