Hello!
So my first problem is as follows;
When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example;
Purchase number;
34598
QTY;
4
I then use a simple Vlookup formula to filter through which event this ticket is attached to.
Once those details are filled that ticket can now be sold. Once sold I currently manually (Here is where I know excel can help), go into another worksheet with the exact same title as the 'Event' listed using the Vlookup and 'populate' a sales table.
The sales table can look as follows;
As you can see; the order number which was a qty of 4 tickets can be displayed 4 times within the same table as each ticket can get dispatched separately, it can be the case where tickets get dispatched to the same person, of course if they buy multiple tickets, however seeing them as individual rows is still necessary for other pieces of data entry.
Pulling Seat & Block numbers can be done using a Vlookup.
What I need the help with is how do I set up the sheet to instruct excel that once I put a purchase number in, with an attached qty, as shown above, to 'print' that in the sheet with the same name pulled from the event list, inside the table?
I appreciate any help!
Thank you,
Harvey12
So my first problem is as follows;
When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example;
Purchase number;
34598
QTY;
4
I then use a simple Vlookup formula to filter through which event this ticket is attached to.
Once those details are filled that ticket can now be sold. Once sold I currently manually (Here is where I know excel can help), go into another worksheet with the exact same title as the 'Event' listed using the Vlookup and 'populate' a sales table.
The sales table can look as follows;
| Order Number | Name | Qty | Seat | Block |
| 34598 | XXXXXX | 1 | 1 | 1 |
| 34598 | XXXXXX | 1 | 2 | 1 |
| 34598 | XXXXXX | 1 | 3 | 1 |
As you can see; the order number which was a qty of 4 tickets can be displayed 4 times within the same table as each ticket can get dispatched separately, it can be the case where tickets get dispatched to the same person, of course if they buy multiple tickets, however seeing them as individual rows is still necessary for other pieces of data entry.
Pulling Seat & Block numbers can be done using a Vlookup.
What I need the help with is how do I set up the sheet to instruct excel that once I put a purchase number in, with an attached qty, as shown above, to 'print' that in the sheet with the same name pulled from the event list, inside the table?
I appreciate any help!
Thank you,
Harvey12
