Sub test()
Call test1
Call test2
End Sub
'筛选
Sub test1()
Application.ScreenUpdating = False
Sheets(2).Select
Cells.Clear
Sheets(1).Select
ActiveSheet.AutoFilterMode = False
With Range("b2").CurrentRegion
.AutoFilter Field:=5, Criteria1:="<>"
.Copy Sheets(2).Range("a1")
.AutoFilter
End With
Sheets(2).Select
End Sub
'求合计
Sub test2()
Dim i
Sheets(2).Select
i = Range("a65536").End(xlUp).Row
Cells(i + 1, "c") = "合計"
Cells(i + 1, "d") = "=sum(d2:d" & i & ")"
Cells(i + 1, "e") = "=sum(e2:e" & i & ")"
End Sub