Sub ss()
h = Sheet1.Cells(Rows.Count, "a").End(xlUp).Row
组数 = Application.WorksheetFunction.RoundUp(h / 16, 0)
For i = 1 To 组数
If i > 1 Then
ha = Sheet2.Cells(Rows.Count, "a").End(xlUp).Row + 1
Sheet2.Rows("1:4").Copy Sheet2.Rows(ha)
hb = Sheet2.Cells(Rows.Count, "a").End(xlUp).Row + 1
Sheet1.Rows(i * 16 - 15 & ":" & i * 16).Copy Sheet2.Rows(hb)
Else
ha = Sheet2.Cells(Rows.Count, "a").End(xlUp).Row + 1
Sheet1.Rows(i * 16 - 15 & ":" & i * 16).Copy Sheet2.Rows(ha)
End If
Next
End Sub