Hi all,
Ive been given a project to do where I have to come up with a system where the following requirements are met:
- find the correct performance on the required date
- check availability for that performance against the customers’ requirements
- calculate the total price of the booking
- update the number of seats available to avoid overbooking (200 seats)
- 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)
Bookmarks