My Theatre Booking System

[Dark RyNo]

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.

 

[Zack Barresse]

Depending on which way you wanted to round ...

=CEILING(A1,4)


=FLOOR(A1,4)


HTH

 

[Dark RyNo]

Thanks. that sounds like what I want but where would I put that?
I have a button with a macro that changes all the seats to =randbetween(1,3)

 

[Zack Barresse]

I have no idea!

Maybe you could do something like this ..

=CHOOSE(RANDBETWEEN(1,3),0,4,8,12)

Maybe I don't understand at all ..