You might find this link to David McRitchie's site covers what you
want to do:

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

Hope this helps.

Pete

On Jul 10, 10:18 pm, Dazed and Confused <Dazed and
wrote:
Not really sure how to explain this... I have three columns of information.
Each column is not very wide but the number of rows is over 200. I can make
the columns where the three are less than half of the width of a printed page.

What I want to do is instead of having multiple pages which are only filled
halfway across I want to print two pages full size side by side... So that
it looks like this:

Page 1
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Page 2
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C

I need to be able to sort ascending and descending for each column as the
list is updated. So, I cannot just copy and paste into new columns... Any
help would be greatly appreciated.