|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub qs()
- Dim arr, i, dic
- Set dic = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion.Value
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 3 To UBound(arr)
- s = arr(i, 4)
- If Not dic.exists(s) Then
- m = m + 1
- dic(s) = m
- brr(m, 1) = m
- For j = 2 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- brr(m, 3) = "'" & arr(i, 3)
- Else
- r = dic(s)
- For c = 5 To 7
- brr(r, c) = brr(r, c) + arr(i, c)
- Next
-
- End If
- Next
- With Sheet2
- .Range("a3:i10000").ClearContents
- .Range("a3").Resize(m, UBound(arr, 2)) = brr
- End With
- Set dic = Nothing
- End Sub
复制代码 |
|