Printing repeating columns on the same page
 

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.

Printing repeating columns on the same page
 

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.

Printing repeating columns on the same page
 

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad
first--large tables cause me trouble in MSWord.

If you're not doing many calculations, you may just want to keep your data in
MSWord, too.

Dazed and Confused 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.

--

Dave Peterson