How can I design an auditorium seating plan so that I can sell tickets by it?

For starters:
-----------------------

- Does this auditorium have seats numbered by row and column?
- You could hide the rows and columns outside the range of the rows
and columns of seats in the auditorium and black fill and lock the
columns corresponding to the isle(s).
- Since some rows in the auditorium usually don't have as many seats
as others, you would lock the appropriate cells corresponding to the
missing seats.
- Put X's in the sold sheets and use an "ON CHANGE" event to update
the status bar with a tally of sold (num x's) and remaining (empty).

--------------------
Ben


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=535381