MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating tickets

Posted by K.Chan on December 26, 2001 5:43 PM


I am a newbie to Excel (but not to computers...).

My question is that I'd like to set up a way to automatically print out tickets from a table that includes: Day, time, Section, Row, Seat, Ticket Price.

In other words, printing the information above would be automatically placed in the exact positions of preprinted tickets (fed through my printer)

Could Excel handle this or should I try Access?

Any help or suggestions would be appreciated... just point me in the right direction!


Posted by Jacob on December 26, 2001 6:17 PM


Excel can do this with formulas of VB.

Lets say you have all you data in columns B:G and in A you have a refernce number:

This in another sheet or in another set of columns use vlookup to get the info.

For example on sheet2 have a place to input a number off the print area like Z1 or whatever

then in the place where you want put the day on the ticket type =vlookup(Z1,A1:G10000,2,false)
for time use =vlookup(Z1,A1:G10000,3,false)

Then when you want to print out a ticket just put the number in Z1 and all the info will be there.

Hope this helps


Posted by K.Chan on December 27, 2001 12:03 AM

Thanks for the quick reply! I'll try this out because it sounds intriguing.