- Sub tianbiao()
- Dim arr, brr, crr, row1%, row2%, rg As Range, n%, m%
- row1 = Sheets("报表").Range("b65536").End(xlUp).Row
- row2 = Range("b65536").End(xlUp).Row
- arr = Sheets("报表").Range("c3", "k" & row1)
- brr = Range("b4", "m" & row2)
- ReDim crr(1 To UBound(brr), 1 To 7)
- For n = 1 To UBound(crr)
- For m = 1 To UBound(arr)
- If brr(n, 1) = arr(m, 1) And brr(n, 4) = arr(m, 4) And brr(n, 12) = arr(m, 9) Then
- If arr(m, 5) = "江门" Then
- crr(n, 1) = crr(n, 1) + arr(m, 3)
- Else
- crr(n, 2) = crr(n, 2) + arr(m, 3)
- End If
- If arr(m, 7) = "利用" Then
- crr(n, 4) = crr(n, 4) + arr(m, 3)
- ElseIf arr(m, 7) = "处置" Then
- crr(n, 5) = crr(n, 5) + arr(m, 3)
- End If
- End If
- Next
- crr(n, 3) = crr(n, 1) + crr(n, 2)
- crr(n, 6) = crr(n, 4) + crr(n, 5)
- crr(n, 7) = brr(n, 3) - crr(n, 1) - crr(n, 2)
- Next
- Range("f4").Resize(UBound(crr), UBound(crr, 2)) = crr
- Range("f4").Resize(UBound(crr), UBound(crr, 2)).SpecialCells(xlCellTypeBlanks) = 0
- End Sub
复制代码 |