Hi

Please could some one tell me how I can make a cell only select certain info
depending on what is put in the previous cell. For e.g

Cell 1 has various options of property type - FLAT, SDH etc
Cell 2 has the option of no of bedrooms 1, 2, 3 and 4

I want cell 2 to only give you certain options depending on property type,
so if a FLAT is selected in cell 1 I only want cell 2 to give the option of
1, 2 or 3

Can anyone help??

Jo