Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: 1 column sheet to multi column page breaked - how to?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Doug Potter
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a single column, 20,000 row worksheet. The single column contains product number (product number order) and price. I have to print a price book. To reduce the number of pages I want to create a multi column version.

    It should read down the first column for first 60 products, then go to the top of the next column and read down the next 60 products and so on for a total of 8 columns.
    Then it would page break and move to the next page to repeat the process and continue to do so until the entire file is converted.

    Any suggestions? Thanks Doug

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Take a look at ASAP Utilities freeware addin at www.asap-utilities.com it has a "paper saver" feature like you're describing.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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