|
Sub tjss() '条件筛选
Application.ScreenUpdating = False
Macro1
Dim Arr, x%
Dim lr As Integer
On Error Resume Next
Rows("17:65536").Delete
With Sheet1
Arr = .Range("A2", .[a65536].End(3)(1, 10))
End With
For x = 1 To UBound(Arr)
If Arr(x, 8) = [B15] And Arr(x, 9) = [C15] And Arr(x, 2) >= [D15] And Arr(x, 2) <= [E15] Then
[a65536].End(3)(2).Resize(1, 10) = Application.Index(Arr, x)
End If
Next
With ThisWorkbook.Sheets(3)
lr = .Range("G65536").End(xlUp).Row
[F15] = Application.WorksheetFunction.Sum(.Range("G17:G" & lr))
End With
Application.ScreenUpdating = True
End Sub 给你一个,参考一下: |
|