|
- Sub aa()
- Dim A
- Dim B, C
- Dim d As Object, i As Integer, j As Integer
- Application.ScreenUpdating = False
- Set d = CreateObject("scripting.dictionary")
- B = Sheets("消费").Range("a1").CurrentRegion
- For i = 2 To UBound(B)
- '如果同一ID有多次消费记录,则要用累加
- 'j = d(B(i, 1))
- 'd(B(i, 1)) = B(i, 3) + j
- d(B(i, 1)) = B(i, 3)
- Next
-
- With Sheets("资料")
- A = .Range("a1").CurrentRegion
- ReDim C(1 To UBound(A), 1 To 1)
- For i = 2 To UBound(A)
- 'If d.exists(A(i, 2)) Then C(i, 4) = d(A(i, 2))
- If d.exists(A(i, 2)) Then C(i, 1) = d(A(i, 2))
- Next
- .Range("d:d").ClearContents
- .Range("d1").Resize(UBound(C)) = C
- .Range("d1").Value = "余额"
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|