Closed Thread
Results 1 to 2 of 2

Stacked Ticket Numbering

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    6

    Stacked Ticket Numbering

    I have perforated ticket stock which has 10 blanks per page. I want each page to contain 10 numbered tickets but to have the tickets "stacked" so theare printed in the order shown below: That way when they are torn apart they will be 'stacked' in correct numerical sequencer. I want to be able to have the form ask for the number of sheets to print and then the number of tickets per sheet (in case I have stock which has a different number of perforated tickets) and then generate a query (or report) that will have the numbers in the correct sequence. I will use the result as a merge file for an InDesign ticket template.
    FIRST SHEET
    "1"
    "11"
    "21"
    "31"
    "41"
    "51"
    "61"
    "71"
    "81"
    "91"
    SECOND SHEET
    "2"
    "12"
    "22"
    "32"
    "42"
    "52"
    "62"
    "72"
    "82"
    "92"
    THIRD SHEET
    "3"
    "13"
    "23"
    "33"
    "43"
    "53"
    "63"
    "73"
    "83"
    "93"
    FOURTH SHEET
    "4"
    14"
    "24"
    "34"
    "44"
    "54"
    "64"
    "74"
    "84"
    "94"
    and so on.......

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Stacked Ticket Numbering

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed 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