Separate 1 column of data into groups of 25 either on new tabs or in new workbook or a column with group number

[Panda514]

Hello,

I have a column with over 600 ID's in it. I need to separate this column by groups of 25. For example, the first 25 people are group 1, then the next 25 people are group 2. I would like these groups to be in different workbooks, but I would appreciate any help to even just label them in another column called Group Number. I'm not sure what the best way to do this is. Maybe a VBA? I don't know how to write those.

 

[Panda514]

I figured out how to make a column that labels the groups. B1 is the cell where you want the first number to be and 25 it the amount you want in the first group.

=INT((ROW(B1)-1)/25)+1

If someone figured out a VBA to split the groups of 25 into separate workbooks that would be awesome!