CMoorhouse
New member
- Joined
- Mar 13, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Do you know how/if I can achieve the following in excel
I am helping someone create a database in excel to manage all their cinema bookings. Example booking:
- Booked by Mr Smith
- Film – Hobbit
- Date – 3[SUP]rd[/SUP] May,
- Time : 8pm
- Party of 5
- Paying by credit card
- Payment received
This part is straight forward but she then wants to record demographic info on the night. How many of the party are in which age group and which sex etc...
The first section is collected across a row in excel. How can she easily add in the additional info without having stacks of columns of age group/sex combination to scroll through.
Can she hit a button that pops up a form to collect the additional info that then inserts it into the main row of data.
The form looking something like this for her to complete each time a new party arrives, entering the numbers of guests in each demographic:
Any ideas gratefully received?
thank you
Caroline
I am helping someone create a database in excel to manage all their cinema bookings. Example booking:
- Booked by Mr Smith
- Film – Hobbit
- Date – 3[SUP]rd[/SUP] May,
- Time : 8pm
- Party of 5
- Paying by credit card
- Payment received
This part is straight forward but she then wants to record demographic info on the night. How many of the party are in which age group and which sex etc...
The first section is collected across a row in excel. How can she easily add in the additional info without having stacks of columns of age group/sex combination to scroll through.
Can she hit a button that pops up a form to collect the additional info that then inserts it into the main row of data.
The form looking something like this for her to complete each time a new party arrives, entering the numbers of guests in each demographic:
| Male | Female |
Under 11 | | |
11-15 | | |
16-24 | | |
25-35 | | |
36-49 | | |
50-64 | | |
65+ | | |
Any ideas gratefully received?
thank you
Caroline