adding multiple additional data fields via a form

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:

Male
Female
Under 11


11-15


16-24


25-35


36-49


50-64


65+





Any ideas gratefully received?

thank you
Caroline
 
Back
Top