Please refer the below link by Debra Dalgleish

on the subject
"Excel -- Data Validation -- Dependent Dropdowns from a Sorted List "
http://www.contextures.com/xlDataVal13.html

"Excel Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

If this post helps click Yes
---------------
Jacob Skaria


"Jo" wrote:

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