运行下面的代码就可以了
Sub 拆分()
Dim sh As Worksheet, sh1 As Worksheet
Set sh = Sheets("sheet1")
For x = 1 To sh.Range("a65536").End(xlUp).Row Step 469
Sheets.Add after:=Sheets(Sheets.Count)
Set sh1 = ActiveSheet
sh1.Cells(1, 1).Resize(469) = sh.Cells(x, 1).Resize(469).Value
Next x
End Sub