|
- Sub 合计()
- Dim arr, brr(), d, i&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("出差记录").Range("a1:v" & Sheets("出差记录").Range("a3").End(xlDown).Row)
- ReDim brr(1 To 100, 1 To 3)
- For i = 4 To UBound(arr)
- x = Split(arr(i, 22), "、")
- s = UBound(x) + 1
- Dim xx
- s2 = (arr(i, 21) - arr(i, 7)) / s
- s1 = arr(i, 7) + s2
- For j = 0 To UBound(x)
- If Not d.exists(x(j)) Then
- n = n + 1
- d(x(j)) = n
- brr(n, 1) = x(j)
- brr(n, 2) = IIf(j = 0, s1, s2)
- Else
- n2 = d(x(j))
- brr(n2, 2) = brr(n2, 2) + IIf(j = 0, s1, s2)
- End If
- Next
- Next
- Sheets("个人差旅费合计").Range("a3").Resize(d.Count, 3) = brr
- MsgBox "汇总完毕!"
- End Sub
复制代码 |
|