I have a VERY simple sheet of two columns.
The name of column 1 is REF
The name of column 2 is NAME
There are 200 possible lines . These lines are SORTED by NAME as soon as
there is a new entry
I would like to able to print as many lines as possible on one or two pages
How do I get the following result ?
----------------------------------------------
REF | NAME | REF |NAME| REF | NAME |
----------------------------------------------
1 | PAUL | 10 | JOHN | 20 | PETE |
2 | JOE | 11 | JACK | 21 | BILL |
3 | FRED | 12 | JIM | 22 | ALAN |
4
5
6
7
8
9
Thanks
Steve
Stephen, have a look here
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Signature
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
>I have a VERY simple sheet of two columns.
> The name of column 1 is REF
[quoted text clipped - 21 lines]
> Thanks
> Steve
Stephen Ellis - 23 Jun 2005 08:29 GMT
thanks for the Word tip : it's easy and it works!
I'll give the Macro a try another day....
Thanks again
Steve