|
- Sub tj()
- Dim rg As Range
- Dim arr
- Dim d As New Dictionary
- Dim i&
- Application.ScreenUpdating = False
-
- Worksheets("sheet1").Activate
- Set rg = Range(Range("a1"), Range("a1").End(xlDown)).Resize(, 3)
- arr = rg.Value
-
- For i = 2 To UBound(arr)
- If Not d.Exists(arr(i, 1) & arr(i, 2)) Then
- d.Add arr(i, 1) & arr(i, 2), arr(i, 3)
- Else
- d(arr(i, 1) & arr(i, 2)) = d(arr(i, 1) & arr(i, 2)) + arr(i, 3)
- End If
- Next
-
- Worksheets("sheet2").Activate
- Range("c:c").ClearContents
- Set rg = Range(Range("a1"), Range("a1").End(xlDown)).Resize(, 3)
- arr = rg
- For i = 2 To UBound(arr)
- arr(i, 3) = d(arr(i, 1) & arr(i, 2))
- Next
- rg = arr
- End Sub
复制代码 |
|