Conditional listing & double selecting

[J_J]

Hi,
I have Sheet1 with names on column A:A and associated department info's on
B:B for each name on A:A.
I want to add names to another sheets (say Sheet2) A:A column. But when I
select a cell on Sheet2 A:A, I want to be able to see the unique depts list
from Sheet1's B:B column. On selecting the dept. I want to see the list of
names from that dept "only". Finally, I want to be able to select from the
names of Sheet1's A:A. Is this possible?
TIA

 

[Frank Kabel]

Hi
as a starting point:
http://www.contextures.com/xlDataVal02.html
and
http://www.xldynamic.com/source/xld.Dropdowns.html

 

[J_J]

Thanks for the links Frank
I think both will be helpful.