|
发表于 2015-9-6 15:39
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- [a:d].Clear
- arr = Sheets("数据源表").[a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- If arr(i, 6) <> "" Then
- x = arr(i, 1)
- n = n + 1
- d(x) = d(x) + 1
- d1(x) = d1(x) & "," & arr(i, 6)
- End If
- Next
- ReDim brr(1 To 1 + Int((n + d.Count) / 4), 1 To 4) '分成四列
- i = 0: j = 1
- For Each x In d.keys
- d1(x) = x & " 计:" & d(x) & d1(x)
- xrr = Split(d1(x), ",")
- For k = 0 To UBound(xrr)
- i = i + 1
- If i > UBound(brr) Then i = 1: j = j + 1
- brr(i, j) = xrr(k)
- If k = 0 Then Cells(i + 1, j).Font.Bold = True
- Next
- Next
- [a:d].NumberFormatLocal = "@" '设置文本格式
- [a2].Resize(UBound(brr), j) = brr
- [a:d].Columns.AutoFit
- [a1] = "单位警号汇总"
- [a1:d1].Merge
- [a1:d1].Font.Bold = True
- End Sub
复制代码 |
评分
-
查看全部评分
|