|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
修改部分代码,注意标星号下方的三行代码:
- ReDim arrData(1 To 4, 1 To 2) As Double
- lngOffSet = lngOffSet + 2
- For lngRows = 1 To lngOffSet
- If arrResult(lngRows, 1) <> "" Then
- arrData(1, 1) = arrData(1, 1) + arrResult(lngRows, 4)
- arrData(2, 1) = arrData(2, 1) + arrResult(lngRows, 6)
- arrData(3, 1) = arrData(3, 1) + arrResult(lngRows, 7)
- arrData(4, 1) = arrData(4, 1) + arrResult(lngRows, 9)
- Else
- arrData(1, 2) = arrData(1, 2) + arrData(1, 1)
- arrData(2, 2) = arrData(2, 2) + arrData(2, 1)
- arrData(3, 2) = arrData(3, 2) + arrData(3, 1)
- arrData(4, 2) = arrData(4, 2) + arrData(4, 1)
- arrResult(lngRows, 3) = "本月合计"
- arrResult(lngRows, 4) = arrData(1, 1): arrData(1, 1) = 0
- arrResult(lngRows, 6) = arrData(2, 1): arrData(2, 1) = 0
- arrResult(lngRows, 7) = arrData(3, 1): arrData(3, 1) = 0
- arrResult(lngRows, 9) = arrData(4, 1): arrData(4, 1) = 0
- '****************************************************
- arrResult(lngRows, 10) = arrResult(lngRows, 4) - arrResult(lngRows, 7)
- arrResult(lngRows, 12) = arrResult(lngRows, 6) - arrResult(lngRows, 9)
- If Val(arrResult(lngRows, 10)) <> 0 Then arrResult(lngRows, 11) = Round(arrResult(lngRows, 12) / arrResult(lngRows, 10), 4)
- lngRows = lngRows + 1
- arrResult(lngRows, 3) = "本年累计"
- arrResult(lngRows, 4) = arrData(1, 2)
- arrResult(lngRows, 6) = arrData(2, 2)
- arrResult(lngRows, 7) = arrData(3, 2)
- arrResult(lngRows, 9) = arrData(4, 2)
- '****************************************************
- arrResult(lngRows, 10) = arrResult(lngRows, 4) - arrResult(lngRows, 7)
- arrResult(lngRows, 12) = arrResult(lngRows, 6) - arrResult(lngRows, 9)
- If Val(arrResult(lngRows, 10)) <> 0 Then arrResult(lngRows, 11) = Round(arrResult(lngRows, 12) / arrResult(lngRows, 10), 4)
- End If
- Next
复制代码 |
评分
-
1
查看全部评分
-
|