breaking sheet of 3000 in to groups of 500

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

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

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