+ Reply to Thread
Results 1 to 4 of 4

Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2013
    Posts
    9

    Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing

    Greetings! New member here. Thank you in advance for spending the time to help a perfect stranger who can't offer anything in return! I just received some awesome help from SKTNEER and SkyWriter; I'm feeling bold enough to ask for a little more, if you wouldn't mind.

    I have a macro which generates a very long list of names, with corresponding data in two other columns. Printing this list wastes a lot of paper. Is there a way to organize it in two columns, so I effectively halve the amount of paper when printing? Please see attached example file. I know my "desired end state" example isn't correct; but it would be alright if I just printed with the "fit all columns on one page" option, like I normally do.

    Please note: the "names" and "speeds" are all different on the actual report. I just used copied the one person a lot to make the example.

    Some code which reorganizes the list after it's been generated would be easiest, because the macro used to get to this point is a beast; I'd rather not make anybody wade through all of it.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-27-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing

    I would have said "bump," but the message was too short! :P

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing

    Can we say, you want to move every 50 rows the 50 rows next rows up on the right?
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    06-27-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing

    Perhaps, but if there were more than 100 rows, I wouldn't want rows 100-150 to be moved up and to the right (creating three master columns). Rather, I'd need rows 100-150 printed on the second page, below rows 1-50. Make sense? This is so it prints out on less paper. Currently, printing the entire list wastes the entire right side of each printed page.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating Single Column List from multi-row/column table and removing blanks
    By ChemistB in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-10-2014, 02:23 PM
  2. How to have 2 Different Printing Layouts for a 2 page macro print job (paper/PDF)
    By bobby.bobby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 04:06 AM
  3. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  4. Replies: 0
    Last Post: 06-14-2012, 11:59 AM
  5. Convert one row and 50 columns of info to a single printable page
    By d5657 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1