VBA编程
Public Sub SplitSheet()
For f = 1 To 3
Worksheets.Add.Name = c
For Each Rng In Sheets("总表").Range("a2:a15")
If Rng.Value = f & "月" Then
n = "a" & Rng.Row & ":d" & Rng.Row
y = y + 1
If y = 1 Then
Sheets("总表").Range("a1:d1").Copy Sheets(f & "月").Cells(y + 1, 1)
End If
Next
y = 0
Next
End Sub
提示Next没有For
End If后面少一个End If