Returning a range of cells from a value
 

I am trying to create a drop down list from a range of data in a spreadsheet (Excel2003) when a specific word is selected in another sheet.

For example If i select from one dropdown list (linked to a cell) the word Spreads, i want a second dropdown list to be populated with a second list from a differrent sheet (same workbook) that contain the list of possible Spreads eg Jam, Marmalade, Honey etc. and then to be able to select the one i want.

Any ideas would be fab

Thanks

C

I think this is what you are looking for:
http://www.contextures.com/xldataval02.html