Connected lists

[nik7]

Hi i have a problem with lists. I have a cell(1) with a drop down list with where i have tow choices and in the other cell(2) i want to have two different lists where when i make a choice in cell(1) i want to give me the proportionate selection list in cell (2).

[majosum]

You could create a virtual named range. Go to "Name Manager" and click "New". Name a new rule and write an IF statement with the two selections as the true or false results. Now for your second drop-down list, just use the name that you created for the rule and it should work fine.

[nik7]

Thnx for the answer but i try it and i can't do it .

[majosum]

I can take a look at it if you include the workbook.

[nik7]

Is ok i finally make it .Thnx