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

Great information, but I am a little confused as to "the code for excel" isnt
finished?
I see the part where I add my parameter info, but I cant find the code to
copy into my VB Editor.

And are you saying it would be easier to put the data in word and use that
marcro?

Barb

"JE McGimpsey" wrote:

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.