|
Sub 拆分工作表()
'
' 排序 Macro
'
' ActiveWorkbook.Worksheets("拆分报表").Sort.SortFields.Clear
' ActiveWorkbook.Worksheets("拆分报表").Sort.SortFields.Add Key:=Range("B2:B9000"), _
' SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
' With ActiveWorkbook.Worksheets("拆分报表").Sort
' .SetRange Range("A1:L9000")
' .Header = xlYes
' .MatchCase = False
' .Orientation = xlTopToBottom
'.SortMethod = xlPinYin
'.Apply
' End With
introw = Sheets("拆分报表").Range("a65536").End(xlUp).Row
str1 = Sheets("拆分报表").Cells(2, 2)
ActiveWorkbook.Sheets.Add(after:=Sheets(Sheets.Count)).Name = str1
For i = 1 To 12
Cells(1, i).Value = Sheets("拆分报表").Cells(1, i).Value
Next
n = 2
For j = 2 To introw
If str1 = Sheets("拆分报表").Cells(j, 2).Value Then
For i = 1 To 12
Cells(n, i).Value = Sheets("拆分报表").Cells(j, i).Value
Next
n = n + 1
Else
str1 = Sheets("拆分报表").Cells(j, 2).Value
ActiveWorkbook.Sheets.Add(after:=Sheets(Sheets.Count)).Name = str1
n = 2
j = j - 1
For i = 1 To 12
Cells(1, i).Value = Sheets("拆分报表").Cells(1, i).Value
Next
End If
Next
End Sub |
-
-
么尤.rar
13.6 KB, 下载次数: 11
把B栏改成G栏引用,分类
|