[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.

2
17
50
83
122
159
189
217
234
267
306
343
376
411
427
461
495
535
573
605
635
653
687
728
766
800

<tbody>
</tbody>

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.