- Sub Macro1()
- Dim arr, brr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- For i = 2 To UBound(brr)
- d(brr(i, 1)) = d(brr(i, 1)) + brr(i, 5)
- Next
- For i = 2 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- arr(i, 4) = d(arr(i, 1))
- Else
- arr(i, 4) = 0
- End If
- Next
- Sheet1.Range("d1").Resize(UBound(arr)) = Application.Index(arr, 0, 4)
- End Sub
复制代码 |