[VBA] How could I split data into multiple sheets by specific row number?

[ffffff]

Hi guys,

I just got a bunch of data in the same column.

For the row number below, those are not necessary for my further action. [TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]83[/TD]
[/TR]
[TR]
[TD="align: right"]122[/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[/TR]
[TR]
[TD="align: right"]189[/TD]
[/TR]
[TR]
[TD="align: right"]217[/TD]
[/TR]
[TR]
[TD="align: right"]234[/TD]
[/TR]
[TR]
[TD="align: right"]267[/TD]
[/TR]
[TR]
[TD="align: right"]306[/TD]
[/TR]
[TR]
[TD="align: right"]343[/TD]
[/TR]
[TR]
[TD="align: right"]376[/TD]
[/TR]
[TR]
[TD="align: right"]411[/TD]
[/TR]
[TR]
[TD="align: right"]427[/TD]
[/TR]
[TR]
[TD="align: right"]461[/TD]
[/TR]
[TR]
[TD="align: right"]495[/TD]
[/TR]
[TR]
[TD="align: right"]535[/TD]
[/TR]
[TR]
[TD="align: right"]573[/TD]
[/TR]
[TR]
[TD="align: right"]605[/TD]
[/TR]
[TR]
[TD="align: right"]635[/TD]
[/TR]
[TR]
[TD="align: right"]653[/TD]
[/TR]
[TR]
[TD="align: right"]687[/TD]
[/TR]
[TR]
[TD="align: right"]728[/TD]
[/TR]
[TR]
[TD="align: right"]766[/TD]
[/TR]
[TR]
[TD="align: right"]800[/TD]
[/TR]
</tbody>[/TABLE]

And I want to extract data from row 3 to 16 as one sheet, 18 to 49 for another sheet, 51 to 82, 84 to 121.......
Please suggest VBA code for spliting those data to different worksheets.

Please help. Thank you!

 

[Joe4]

You are welcome!

Yeah. True, I am trying to put line break now.

You may not even need that. If you had some sort of repeating header or trailer, we could use that as well.