需求:数据表名这列相同的表,汇总数据要素,并以、隔开
效果
实现代码:
Sub test()
Application.ScreenUpdating = False
n = 1
Set d = CreateObject("scripting.dictionary")
arr = [a1].CurrentRegion
For i = 1 To UBound(arr)
d(arr(i, 1)) = d(arr(i, 1)) & arr(i, 2) & "、"
Next
[e1].Resize(d.Count) = Application.Transpose(d.keys)
cnt = d.Count
k = d.items
d.RemoveAll
For j = 0 To cnt
On Error Resume Next
brr = Split(k(j), ",")
For m = 0 To UBound(brr)
d(brr(m)) = ""
Next
Cells(n, "f") = Join(d.keys, ",")
Cells(n, "F") = Left(Cells(n, "f"), Len(Cells(n, "f")) - 1)
n = n + 1
d.RemoveAll
Next
Cells(Rows.Count, "F").End(3).Delete
Application.ScreenUpdating = False
End Sub