|
Sub test()
Set d = CreateObject("scripting.dictionary")
With Sheet1
arr = .Range("A1").CurrentRegion
For i = 2 To UBound(arr)
If Not d.exists(arr(i, 1)) Then
ReDim brr(1 To 6, 1 To 1)
For j = 2 To 7
brr(j - 1, 1) = arr(i, j)
Next
d(arr(i, 1)) = brr
Erase brr
Else
brr = d(arr(i, 1))
' brr = Application.Transpose((brr))
n = UBound(brr, 2)
n = n + 1
ReDim Preserve brr(1 To 6, 1 To n)
For j = 2 To 7
brr(j - 1, n) = arr(i, j)
Next
d(arr(i, 1)) = brr
Erase brr
End If
Next
For Each aa In d.keys
xm = aa
sz = Application.Transpose(d(aa))
Workbooks.Add
With ActiveWorkbook.Sheets(1)
.Range("B1").Resize(UBound(sz), UBound(sz, 2)) = sz
.Range("A1").Resize(UBound(sz)) = aa
End With
ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & aa & ".xls"
ActiveWorkbook.Close True
Next
.Range("a17").Resize(1, UBound(k) + 1) = k
End With
End Sub
|
评分
-
1
查看全部评分
-
|