Hi all,

Ive been given a project to do where I have to come up with a system where the following requirements are met:

  1. find the correct performance on the required date
  2. check availability for that performance against the customers’ requirements
  3. calculate the total price of the booking
  4. update the number of seats available to avoid overbooking (200 seats)
  5. print a receipt for the customer showing total tickets bought.

I would say I have a good grasp of excel including named ranges, Vlookups, nestedIf's, SumIF and basic Macros/VB however I am not sure how I would set this up as there is no allocated seats just a total number required by the customer for a chosen show/date.

Any help would be greatly appreciated for any part of the problem, if anymore info is required please ask.

Cheers

Turly

Additional Info that may be of use:

3 price bands - Pro/Amateur/Local
Within each of those Adult/OAP/Child (dummy data will be used)