Help....I am making a book and need to make it fewer pages
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Help....I am making a book and need to make it fewer pages

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

    Default

     
    Hello.......

    I have about 30,000 rows with 4 columns to each row. I need to make another "set" next to the first........in otherwords I need to make rows 1-15 and 16-30 on the same page with 31-45 and 46-60 on the next page.

    Is there an easy way to do this?

    Thanks
    Ed.


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm Lost?
    You said you need to make fewer sheets?
    If I understand your goal parameters, you want, from 1 to 30000, to be broken up in increments of 15 rows?
    You have enough room for 64 sets of 4 per sheet. 64 * 15 = 960 rows of data per sheet.
    30000 / 960 = about 32 sheets needed.
    Is this what you are attempting?
    Thanks,
    Tom

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TsTom posted his reply while I was writing this, but I'll stick it in here anyway:

    The "easy" way would involve using a macro.

    I need some clarification. You say you have 30,000 rows on one sheet. Essentially, what you want to do is take the data from rows 1 - 30 and place a copy on the next sheet in the workbook. Then you want to take the data in rows 31-60 and place a copy on the sheet after that, and so on and so forth until you have copied every set of 60 consecutive rows to a new sheet?

    So basically, you'll have a workbook with a sheet with 30,000 rows of data and then 500 sheets with 60 rows of data each on them? (That's a heck of a lot of sheets)

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think I need to clarify what I want to do.......The book I am making is a price guide with 4 columns. The book has 30,000 items in it. Instead of having one document that has 30,000 lines in it I want to make it 15,000 lines. I cant simply go down to line number 14,999 and cut and paste it next to the first set because it is all in alphabetical order. It has to stay in alphabetical order so that people can look up items and find their price. Basically, rows 1-15 need to be on the left side of the printed page and then 16-30 need to be on the right side of the printed page....and then the next printed page start with row 31.

    I hope this clears up what I am trying to do a little bit.

    thanks
    Ed.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    449
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    try copying it into a word document and format word document with 2 columns this will then wrap the test onto fewer pages you can then save as a text file and import it bac into excell

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
  •  

 

 
DMCA.com