double dropdown/combobox

[arie]

i have 8 offices with each 12 employees. in column A i want to select
(with a combobox?/dropdown?) a certain office and then in column B
appears a combobox/dropdown(?) with the 12 employees of that office. i
know this is possible but i don't know how. maybe there is somebody out

there who can help me.
thanks very much for your help.
regards
arie

 

[Peo Sjoblom]

http://www.contextures.on.ca/xlDataVal02.html

 

[Norman Jones]

Hi Arie,

See Debra Dalgleish's page on dependent lists at:

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

See also xlDynamic's page on dependent dropdowns at:

http://www.xldynamic.com/source/xld.Dropdowns.html

 

[arie]

peo and norman,
thanks for your help so far,
because i am a total newby additional help would be much appreciated:

list of 8 offices:

office

no
oo
mn
nw
zh
zw
zo
hk

each office with 12 employees:

no oo mn nw zh zw zo hk

no01 oo01 mn01 nw01 zh01 zw01 zo01 hk01
no02 oo02 mn02 nw02 zh02 zw02 zo02 hk02
no03 oo03 mn03 nw03 zh03 zw03 zo03 hk03
no04 oo04 mn04 nw04 zh04 zw04 zo04 hk04
no05 oo05 mn05 nw05 zh05 zw05 zo05 hk05
no06 oo06 mn06 nw06 zh06 zw06 zo06 hk06
no07 oo07 mn07 nw07 zh07 zw07 zo07 hk07
no08 oo08 mn08 nw08 zh08 zw08 zo08 hk08
no09 oo09 mn09 nw09 zh09 zw09 zo09 hk09
no10 oo10 mn10 nw10 zh10 zw10 zo10 hk10
no11 oo11 mn11 nw11 zh11 zw11 zo11 hk11
no12 oo12 mn12 nw12 zh12 zw12 zo12 hk12

i want to be able to choose from a dropdown list one of the 8 offices,
lets say nw
and than be able to choose an employee out of the second dropdown with
the 12 employees, lets say nw11

i hope i make myself understandable enough.
many thanks for your help.
regards
arie

 

[Peo Sjoblom]

Create the office lists first, select each list (one by one) then do
insert>name define and name each list, then create
a list with the office names you just created and name that too (Offices
maybe?).

Apply the first validation, allow>list and use =Offices (or whatever you
named the last list)
then apply a second validation, allow>list and use =INDIRECT(B2)

where B2 is the cell where you have the Offices validation list
--
Regards,

Peo Sjoblom

(No private emails please)

 

[arie]

peo,
this only works with the first office: no
i did the validation like you said. when i select the first office, no,
i get the list of the employees, no01-no12, so far so good. but when i
select lets say office hk, i still get the employees no01-no12.
what am i doing wrong???
thanks
arie


Peo Sjoblom schreef:

 

[arie]

peo,
i just tried your guideline again and now IT WORKS!
thank you very much.
arie