help

[itzik]

Hello
I need to print a data sheet.
The data are arranged in two columns.
One column sequential numbering
Second column names of people
If I print in this situation, on each page will be printed one column of numbers and one column of names.
I need a macro to convey the columns so that when I will print the data several columns will be printed on one page.
Thanks
itzik

name
1 aaaaa bbbbbbbb
2 aaaaa bbbbbbbb
3 aaaaa bbbbbbbb
4 aaaaa bbbbbbbb
5 aaaaa bbbbbbbb

 

[Special-K99]

There may be a better way but when I do this I created a template in Word with columns then pasted the data from Excel into the Word and printed from Word.

By the way, a better title for this word be a description of the problem you have rather than just the word "Help". The fact you're posting something to this board already is an indication you require help.

 

[Peter_SSs]

Not a macro, but see if this idea could be any use to you.
http://www.mrexcel.com/forum/showpost.php?p=974107&postcount=3