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!