这个汇总的语句是对了,你之前把错的也已经发过了,我现在想问的是,这个筛选的功能能改成所有列都有吗现在的语句是:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$C$2" Then Exit Sub
ActiveSheet.AutoFilterMode = False
Range("C5:C" & [C65536].End(3).Row).AutoFilter Field:=1, Criteria1:="=*" & [c2] & "*"
If Target.Address <> "$E$2" Then Exit Sub
ActiveSheet.AutoFilterMode = False
Range("E5:E" & [C65536].End(3).Row).AutoFilter Field:=1, Criteria1:="=*" & [e2] & "*"
End Sub