View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Move Data from one column to many columns

See

http://www.mvps.org/dmcritchie/excel/snakecol.htm

In article ,
"Barb" wrote:

I have a spreadsheet with thousands of entries in one column.
I would like to have a macro that can move every 100 rows of data over to
the next column and so on.

Goal is to fill up pages so I can print less sheets filled up with data.