|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
代码更新。。。
- Sub ykcbf() '//2024.5.23
- Dim arr, brr, d, s
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("b8")
- r = .Cells(Rows.Count, 1).End(3).Row
- Set Rng = .Range("a4:i" & r)
- With ActiveSheet.Sort
- .SortFields.Clear
- For x = 1 To 4
- .SortFields.Add2 Key:=Rng.Columns(x + 1), SortOn:=0, Order:=1
- Next
- .SetRange Rng
- .Header = 2
- .Apply
- End With
- arr = Rng.Value
- For i = 1 To UBound(arr)
- s = arr(i, 2) & "|" & arr(i, 3) & "|" & "|" & arr(i, 5)
- If Not d.exists(s) Then
- d(s) = Array(arr(i, 2), arr(i, 3), arr(i, 5), arr(i, 6), arr(i, 7), arr(i, 8))
- Else
- t = d(s)
- t(3) = t(3) & "、" & arr(i, 6)
- t(4) = t(4) & "、" & arr(i, 7)
- t(5) = t(5) + arr(i, 8)
- d(s) = t
- End If
- Next
-
- .[l17:q1000] = ""
- With .[l17].Resize(d.Count, 6)
- .Value = Application.Rept(d.items, 1)
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- End With
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
|