Reply to thread

Message: [QUOTE="Matt, post: 3791124"] Hi folks!!! I'm kinda stuck and need a little guidance. I have created a spreadsheet for tracking hotel bookings, Revenue from the bookings and commission paid. What I would like to is to be able to have the spreadsheet automatically add new rows as I run out space. Currently I have around 100 rows dedicated to this, but it will only take a couple of days to fill those row before I need more. It looks something like this. The headers begin in A4 and go as follows:- (Columns I-N all have a width of zero so they appear hidden) A - Reservation Number B - Source of booking (dropdown box - Choices = Web, Worldspan, Pegasus, Galileo, Amadeus, Sabre) C - Arrival date D - Number of nights E - Number of people F - Total booking value G - Average room rate (contains formula - Total booking value divided by number of nights - F5 divided by D5) H - Meals included (dropdown box) I - Room revenue (contains formula - =IF($H8="Breakfast",$E8*6," ") J - Breakfast Revenue (contains formula - =IF($H5="Breakfast",$E5*6," ") K - Dinner Revenue (contains formula - =IF($H5="Dinner",$E5*17.95," ") L - Dinner, bed and breakfast revenue (contains formula - =IF($H5="DBB",$E5*23.95," ") M - Room only (contains formula - =IF($H5="Room only",$E5*0," ") N - Total food revenue (contains formula - =SUM(J5:M5)*D5 O - Net room revenue (Contains formula - =IF(F5=0,"",I5/1.175) P - Net food Revenue (contains formula - =SUM(N5/1.175) Q - Enhance revenue R - Total net revenue (Contains formula - =SUM(O5:Q5) S - Comission paid (contains formula - =IF(B5="Web",G5/100*6*D5,IF(B5="Amadeus",3.25+D5*G5/100*5,IF(B5="Sabre",3.25+D5*G5/100*5,IF(B5="Worldspan",3.25+D5*G5/100*5,IF(B5="Galileo",3.25+D5*G5/100*5,IF(B5="Pegasus",3.25+D5*G5/100*5)))))) All cells with formulas are locked and the sheet protected. I appreciate that there are probably easier way to achieve the results that I have, but I just want to point out that I am self taught with Excel which is why I have probably gone about it all the long way. :) I have done a search and found a couple of topics where people have a similar situation to me, but they all seem to require the use of VB. The problem is that I have never even looked at VB before and am easily confused by it. Is there a simpler way to achieve what I want? If not, does anyone know where I can find a complete idiots guide to using VB? Many thanks in advance Matt [/QUOTE]

Verification