|
本帖最后由 ykcbf1100 于 2024-6-25 11:16 编辑
改一句代码就可以了。
- Sub ykcbf() '//2024.6.25
- Dim arr, brr, d
- Application.ScreenUpdating = False
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("Sheet1").Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 100)
- For i = 2 To UBound(arr)
- s = arr(i, 1)
- If Not d.Exists(s) Then
- m = m + 1
- d(s) = m
- brr(m, 1) = m
- brr(m, 2) = arr(i, 1)
- End If
- r = d(arr(i, 1))
- n = 2 + Day(arr(i, 3))
- brr(r, n) = IIf(InStr(brr(r, n), arr(i, 2)), brr(r, n), brr(r, n) & IIf(brr(r, n) = "", "", "、") & arr(i, 2))
- Next
- With Sheets("Sheet2")
- .UsedRange.Offset(7).Clear
- With .[a8].Resize(m, 33)
- .Value = brr
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|