breaking sheet of 3000 in to groups of 500

Highlighted
New Contributor

can i take a sheet of 3000, and break it in to six sheets of 500 each? how ? thanks!  

3 Replies
Why would you want to do that? Splitting the data over multiple sheets makes it harder to do reporting on all of the data.
Highlighted

no. this is just for simple mail outs. 3 to 5 columns. sorry, i just dont know excel.

Highlighted
No problem! How would you decide which rows need to go on which sheets?