Sub demo()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim biaoti As Range, pihao As Range, rng As Range, mypath$
Set biaoti = Range("A1:H1")
For Each pihao In Range("H2", [H2].End(xlDown))
Set rng = pihao.EntireRow
If pihao.Value <> pihao(0, 1).Value Then
If ActiveWorkbook.Name <> ThisWorkbook.Name Then ActiveWorkbook.Close 1
Workbooks.Add.SaveAs ThisWorkbook.Path & "\" & pihao.Value & ".xlsx"
biaoti.Copy [a1]
rng.Copy [A2]
Row = 2
Else
Row = Row + 1
rng.Copy Range("a" & Row)
End If
Next
ActiveWorkbook.Close 1
End Sub
祝順心,南無阿彌陀佛!