Data validation excel 2007

[Weronika]

Hi All,

Would someone be able to help me out with an excel data validation please? I have got a spreadsheet where three columns are set up using data validation and what I would like to get is dependent list based on the first column.

Thanks a lot for any help,
Weronika

 

[VoG]

This is for earlier versions of Excel but the principles ate the same http://www.contextures.com/xlDataVal02.html

 

[Weronika]

Hi,

Thank you vare much for quick reply, this link is very helpfull, hope I found what I need.

Thanks again,
Weronika