Hello all,
I have a problem...

I have many spreadsheets, each have 10000+ rows...
I would like them to be printer friendly...

The excel file has no headings... only data, and only one row..

example:

A
--
00001
00002
00003
00004
...
11234

I would like to have these values separated into many columns, (grouped by 52)...

so for example in column A I would have the first 52 rows, column B would contain the next 52, column C would contain the next 52... I know this is possible, the macro I tried to make grossly fails because of my loop ignorance, any help would be greatly appreciated. Thanks