|
Sub ttt()
Set d = CreateObject("scripting.dictionary")
Application.ScreenUpdating = False
arr = Sheets(1).UsedRange
c = 1
For j = 1 To UBound(arr, 2)
If arr(1, j) = "" Then arr(1, j) = arr(1, j - 1)
If Not d.exists(arr(1, j)) Then
Set d(arr(1, j)) = Sheets(1).Cells(1, j)
Else
Set d(arr(1, j)) = Union(d(arr(1, j)), Sheets(1).Cells(1, j))
End If
Next j
For j = d.Count - 1 To 0 Step -1
d(k).EntireColumn.Copy Sheets(2).Cells(1, c)
c = c + d(k).Cells.Count
Next j
Application.ScreenUpdating = True
End Sub
|
评分
-
1
查看全部评分
-
|