Dropdownmenu with creteria for the next dropdown menus

[abjac]

Hi I have a dropdown menu in sheet 1, taken from Sheet3. The idea is when you select a country, it will select the other items in the next 3 dropdown menues, taken from how it is in sheet 3 for this specific country

Exsample if i select Finland under dropdown menu country. It will give me following choices in the next 3 dropdownmenues.

Tranmittal code.. FIF only this one.
Ledger codes... choose between 10 and 35 and 6x
Country Code.. Can only be 702

So its the selection of the Country dropdown menu, which dicide, what can be in the next 3 dropdown menues.

In the real one there can be many countryes with many different info. So to have this will be a help.

IN my dropdown menu for country i also cant remove the space, would be important to solve that too,

Have a look and the test sheet i send.

If there can be other solutions maybe with pure vba code would be interesting too

Thanks in advance
Sincerely
Abjac

[Richard Buttrey]

Hi,

I can do no better than point you to Debra's site where you'll find all you ever need to know, (and more) on this subject.

http://www.contextures.com/xlDataVal02.html

[abjac]

Interesting site Richard thanks allot will have a look, will let the thread open a while to see if any other answers will come. But its interesting thanks allot.
Sincerely

Abjac