Hello everybody, I was wondering if anybody could help me with the following problem. I am currently writing this email to you from my sixth form college in Ilford, England. I am 17 years of age. I have a project to do on the sales and preparation of a banquet ball which is to be implemented using Microsoft Excel.

Ok, here's the problem. I have a worksheet with a set of values which shows the number of seats in one hall. What I have done at the moment is to insert a combo box so that you can select from three names of halls and then the name of the hall is inserted into a cell. What i would like to do the though is to actually have the name of the hall inserted into a cell and as well as this, a row from the worksheet filled with the relevant number of seats for each hall name. Could someone help me on how I can actually achieve this?

Thank you for your help.