|
楼主 |
发表于 2014-9-27 10:11
|
显示全部楼层
Sub NewSht()
Dim Sh As Worksheet
Dim Arr, k&, Ary, i&
Dim Dic As Object, Itm
Set Dic = CreateObject("Scripting.Dictionary")
Set Sh = ActiveSheet
Arr = [A1].CurrentRegion
For k = 2 To UBound(Arr)
Dic(Arr(k, 6)) = ""
Next
For Each Itm In Dic
Ary = Arr: i = 1
For k = 2 To UBound(Arr)
If Arr(k, 6) = Itm Then
i = i + 1
Ary(i, 1) = Arr(k, 1)
Ary(i, 2) = Arr(k, 2)
Ary(i, 3) = Arr(k, 3)
Ary(i, 4) = Arr(k, 4)
Ary(i, 5) = Arr(k, 5)
Ary(i, 6) = Arr(k, 6)
Ary(i, 7) = Arr(k, 7)
End If
Next
Sheets.Add after:=Sh
ActiveSheet.Name = Itm
ActiveSheet.[A1].Resize(i, 7) = Ary
Next
Dic.RemoveAll
End Sub
|
|