+ Reply to Thread
Results 1 to 3 of 3

Producing tickets -- transferring data from a continous table to discrete tickets

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    London
    MS-Off Ver
    Windows 7 64-bit
    Posts
    2

    Producing tickets -- transferring data from a continous table to discrete tickets

    Hi folks. Hope you are all doing well.

    I need to create a ticket system in Excel where I can input data into a table, and that data then gets copied over into a set of "tickets" that can be printed continuously on one page.

    Say there are 2 worksheets in my workbook. Call one of them "TABLE WORKSHEET" and the other "TICKET WORKSHEET".

    TABLE WORKSHEET has 3 columns: DATE | NAME | AMOUNT. The values to be inputted into these columns will run down the rows, continuously.


    TICKET WORKSHEET contains separate boxes [i.e. the tickets] that are spaced at regular intervals. The boxes each have 2 rows and 3 columns. The 3 columns are the same as TABLE WORKSHEET. One of the two rows is obviously for the title DATE | NAME | AMOUNT. The other row is for the value of these titles [the same values as will be entered into the table]. The boxes run down the page, so that the whole thing can be printed at once [ticket after ticket]. That's how it is designed.

    So what's happening [as you have probably guessed], is that as I am entering data into the table, the individual tickets are being filled out, continuously.

    That's it. Very basic. What can I use in Excel for this? One basic thing was linking rows of cells from both worksheets together. But this is obviously impractical to do, as we are working with hundreds of tickets [therefore, hundreds of rows of cells would need to be linked]. I want to be able to enter the values into the table, and for that to be distributed to the tickets in a continuous fashion.

    Are there any shortcuts to this that you guys can think of? The tickets will be printed on pages. Generally, each page will have around 6 tickets. So I have 6 boxes on each page.

    Any pointers to things I could learn would be helpful.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,015

    Re: Producing tickets -- transferring data from a continous table to discrete tickets

    No need to reinvent the wheel! What you need is to set up your database in Excel and then your ticket template in Word. Check out mail merge here: https://support.office.com/en-us/art...9-0ec3a4b011b2
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    12-15-2017
    Location
    London
    MS-Off Ver
    Windows 7 64-bit
    Posts
    2

    Re: Producing tickets -- transferring data from a continous table to discrete tickets

    Thanks for the advice, AliGW!

    I guess I was thinking it could all be done in Excel... such that I would basically have one file that I would be able to click on which would contain all the relevant data.

    But I guess I will look into your solution.

+ 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