Print Multiple Sheets On One Page

My problem is that I work with a large number of 3 column lists. Inevitably I have to print these out and hate the fact that they sometimes use up to 100 sheets of paper.

It would be great if there was a way to print it to just 50 sheets.

For example if you had a class list of 100 students sorted alphabetically:

Name Grade Age
Ann 8 13
Bob 9 14

etc, etc

these 3 columns only take up half the page or less. Is there a way to print page 1 and 2 on the first piece of paper and the 3 and 4 together etc etc...

Any help would be great.

In the past I have manually moved cells around but that's a lot of work. The trick is that I would need them to be sorted alphabetically still so I can just go half way down the sheet and copy and past them bottom half into columns e to f.

Originally Posted by outthere

My problem is that I work with a large number of 3 column lists. Inevitably I have to print these out and hate the fact that they sometimes use up to 100 sheets of paper.

It would be great if there was a way to print it to just 50 sheets.

For example if you had a class list of 100 students sorted alphabetically:

Name Grade Age
Ann 8 13
Bob 9 14

etc, etc

these 3 columns only take up half the page or less. Is there a way to print page 1 and 2 on the first piece of paper and the 3 and 4 together etc etc...

Any help would be great.

In the past I have manually moved cells around but that's a lot of work. The trick is that I would need them to be sorted alphabetically still so I can just go half way down the sheet and copy and past them bottom half into columns e to f.

Hi

I suppose that you have one file.All your datas are on the first sheet like this:
Ann 8 13
Bob 9 14
Jim 14 27
......
......

Let's say that you have 240 rows without title (Name Grade Age) and your three columns.If you use the following macro:

Please Login or Register  to view this content.

you'll have 56 rows and 15 columns.It's not exactly what you want, i know but i think that you'll win paper.You should have:

Ann 8 13 Mark 20 17........
Bob 9 14 Leon 5 14.......
Jim 14 27 Stu 8 20......

Sorry if you see mistakes.I don't speak english.

THANKS.

That will work with a little tweaking on my part. I have no idea how to write the code that goes into macros but I can logically work through what you created.

THANKS AGAIN!!!

Originally Posted by outthere

THANKS.

That will work with a little tweaking on my part. I have no idea how to write the code that goes into macros but I can logically work through what you created.

THANKS AGAIN!!!

You're welcome.Could you please indicate precisely how many rows you have.Open Tools/Macro/Macros.Give a name and click on Create.You'll see a new window.You have just to paste the code between Sub "The name of your macro"() and End Sub.Close the window.To execute the macro, open Tools/Macro/Macros/Select your macro and click on Execute or double-click on the name.