Im Making a theatre booking system for a project in my ICT class.
What I have so far, is the layout of my theatre with each seat as a cell. They have drop down boxes that I can set as Available, Adult, Concessions or Family Ticket. Then formulas and stuff figure out how much money I bring in.
This all works.
I would like to do 2 things.
Firstly, make a macro on a button to reset all the cells in the theatre layout back to "Avilable"
Any help?
Secondly, I would like a second sheet that, when I change a cell to Adult or the other "sold" options, I want it to tell me which tickets I need to write out.
So it would have a list of sold seat numbers and whether they are Adult, Concession or Family.
Is there any way to do this?
Thanks, this website already gave me the help on the drop down boxes.
What I have so far, is the layout of my theatre with each seat as a cell. They have drop down boxes that I can set as Available, Adult, Concessions or Family Ticket. Then formulas and stuff figure out how much money I bring in.
This all works.
I would like to do 2 things.
Firstly, make a macro on a button to reset all the cells in the theatre layout back to "Avilable"
Any help?
Secondly, I would like a second sheet that, when I change a cell to Adult or the other "sold" options, I want it to tell me which tickets I need to write out.
So it would have a list of sold seat numbers and whether they are Adult, Concession or Family.
Is there any way to do this?
Thanks, this website already gave me the help on the drop down boxes.