• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Format - like ticket booking

S

sdsurzh

Member
Hi,


I am looking for blocking a seat for different shifts in excel format (similar to movie ticket booking.....Select date,select # of seats,showtime & Price). Does any body have or help on this.


Thanks in advance,

Suresh Kumar S
 
You can certainly do this, but it some effort to set up. The way I visualize it is you have your table/range of cells used to represent seats. Each seat then has a formula determining checking whether the price of that seat is <= selected price, and at the specific time (which includes date and showtime) is seat available (this data would also need to be stored). If it is, evaluate to true and/or highlight via conditional formatting. To get extra fancy, you could use the double_click event macro to make it so that if you double click on the cell, it changes the values in seat available table to "taken" and disappears.


I'm not sure how much of this work you are needing guidance with (just wanted idea, stuck on portion, needed entire workbook). Could you elaborate on what exact help you are needing?
 
Hi Excel Heros,


As adviced by Luke i have created a workbook. Now i have 2 conditions and i have explained in the worksheet. Please provide the codes for 2 conditions.


http://www.2shared.com/document/EWSdkMiI/schedule.html


Thanks in advance,

Suresh Kumar S
 
@Suresh Kumar


Hi


still i am also waiting for the replay of your thread from Ninja's from last night


so i think why not we create with our own knowledge


what do you say


off course i have not that much of idea


i check your file you specify the range from aa1 to ae1 which is copied to out put sheet


is it possible to insert the check box no. in af1, if it possible then we will create a user form which check the Date and the No. of Check Box. if the no. is already in that COLUMN then a msg box will appear you can choose the seats and display the seat non listed seat nos


Thanks


SP
 
Thanks sgmpatnaik,


Let me try to modify as suggested by you and if in case any issues i will alarm.


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top