Breaking up a long list into different worksheets

Hi,

In Column A of Worksheet "MAIN", starting from Row 2, I have a list of student's name (the number is not fixed, range from 450 to 800). What I want to do is to have this list cut-up into pieces of 30 and then copied into new worksheet.

For example, the first 30 names will be paste special into a newly created Worksheet named "List1", the next 30 into Worksheet named "List2" ... and so on.

Could anyone please help with the VBA code. Thank you in advanced. Cheers!

Try this.

Please Login or Register  to view this content.

Thank you so much. Very much appreciated.