Sorting a list into columns

[Rlyeh462]

Hi. I need help sorting a list from one worksheet into 3 seperate columns on another worksheet. The list is already alphabetized and designed to be a dynamic list with a changing size. Each column has to be in 52 line sets for printing purposes. The list should go from a1-a52 then move to b1-b52 etc. When all four columns are filled it would move to a53-a104 etc. I've tried a variety of for-next loops, but I can't seem to get it right. I've included an example spreadsheet with no coding just to better show what I'm trying to do. Thanks in advance.

[Andy Pope]

Try this,

Please Login or Register  to view this content.

[Rlyeh462]

Thank yo, that worked perfectly