|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
请见代码:
- Sub gj23w98()
- Dim brr(1 To 99999, 1 To 7)
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.[a1].CurrentRegion
- For i = 2 To UBound(arr)
- s = arr(i, 8)
- If Not d.exists(s) Then
- m = m + 1
- d(s) = m
- brr(m, 1) = arr(i, 14)
- brr(m, 2) = arr(i, 15)
- brr(m, 3) = arr(i, 8)
- brr(m, 4) = arr(i, 7)
- brr(m, 5) = arr(i, 11)
- brr(m, 6) = arr(i, 13)
- brr(m, 7) = arr(i, 12)
- Else
- brr(d(s), 7) = brr(d(s), 7) + arr(i, 12)
- End If
- Next
- If m Then [a2].Resize(m, 7) = brr
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|