|
漏写了点代码,光建新表没有复制过去,改过来,你测试一下。
Sub 拆分工作表()
Dim rng As Range, endRng As Range, sht As Worksheet
Dim shtname$, temp As Range
Set endRng = Sheet8.Cells(Rows.Count, 1).End(3)
Set temp = Sheet8.Rows(2)
Application.ScreenUpdating = False
For Each rng In Sheet8.Range(Cells(3, 1), endRng)
For Each sht In Sheets
shtname = shtname & "\" & sht.Name
Next
If InStr(shtname, rng.Value) Then
rng.EntireRow.Copy Sheets(rng.Value).Cells(Rows.Count, 1).End(3).Offset(1)
Else
Worksheets.Add(after:=Sheets(Sheets.Count)).Name = rng.Value
temp.Copy Sheets(rng.Value).[a1]
rng.EntireRow.Copy Sheets(rng.Value).Cells(Rows.Count, 1).End(3).Offset(1)
End If
shtname = ""
Next rng
Application.ScreenUpdating = True
End Sub
|
评分
-
查看全部评分
|