Microsoft Excel - Linking Data

airwalk_90

Hi there -

how do i link data in excel?

My problem is that I want to assign attributes to names in a drop down list. So if i chose x in the drop down list, then attributes a,b,c will appear in the next column. and when i chose y in the drop down list, then attributes d,e,f will appear in the next column and so on... can anyone help me please?

i.e. depending on what i pick from the drop down list in column A, will dictate what i can pick in the drop down list in column B.

Thanks in advance.