split a list into multiply sheets

Hi,

I'm having a long list (about 10000 cells) on one column that i would like to split it into different sheets that each sheet will contain about 200-300 copied cells, doesn't matter what is the content of the cell.

Thanks

Hi, Try this:- The code will Copy column "A" in activesheet in sections of 300 cells, add a new sheet for each new 300 cells, and paste the copied Data to column "A".

Please Login or Register  to view this content.

Regards Mick