|
Option Explicit
Sub TEST5()
Dim ar, br, cr, i&, j&, r&, dic As Object, strKey$
Set dic = CreateObject("Scripting.Dictionary")
r = Cells(Rows.Count, "A").End(xlUp).Row
With Range("E1:I" & r)
ar = .Value
For i = 2 To UBound(ar)
strKey = Left(ar(i, 1), 4)
If Not dic.exists(strKey) Then
br = .Cells(i, 2).Resize(, 4)
br(1, 1) = strKey
dic(strKey) = br
Else
br = dic(strKey)
cr = .Cells(i, 2).Resize(, 4)
For j = 2 To UBound(cr, 2)
br(1, j) = br(1, j) + cr(1, j)
Next j
dic(strKey) = br
End If
Next i
End With
Columns("U:X").Clear
[U1].Resize(, 4) = Split("结果代码 借方金额 贷方金额 余额")
[U2].Resize(dic.Count, 4) = Application.Rept(dic.items, 1)
Set dic = Nothing
Beep
End Sub
|
评分
-
1
查看全部评分
-
|