Macro to copy and paste a single column into several different columns

Hi all,

So what I have is a column that can be from 200-500 cells long. I want a macro to copy these into several columns on a new sheet so that I can print it landscape and they will be displayed next to eachother instead of one just really long column.

Can I do this?

Thanks,

Matt

Hi - I think what you are after is called "snaking", maybe have a look here for some examples:
http://answers.microsoft.com/en-us/o...5-bd6aa7f869da

You can also paste it into word and then format it into columns to get the same thing.