MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating tickets


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

Hello,

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!

K.C.


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

Hi

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)
etc

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

Jacob

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

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