+ Reply to Thread
Results 1 to 2 of 2

Rounding up:printing out sheets

  1. #1
    Registered User
    Join Date
    09-01-2006
    Posts
    1

    Rounding up:printing out sheets

    I am trying to find a way to round from 1.1-1.9 and have it as 2

    The reason I need to do this is that I am printing out sheets of paper that have store ids for some reps. I can only fit 6 on a page I have it set so if its 6 on a page I am good if I go to 7 it goes to 1.2 and 8 is 1.3 and so on. Therefore, when I get to 11 I am at 1.8 and 12 will put me at 2 pages I will use.

    What I need to do is take the ones with decimals and round them up so I will see 2 pages when itís 1.1 or higher.

    Thank you,
    Charles

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Using a helper column.

    Enter =ROUNDUP(A1,0). Change A1 to start of your range and drag down.

    Then select your column with the 1.1, 1.9 etc. Right click while selected and select hide. This will hide the column so your print area will stay the same

    VBA Noob

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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