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

--
Regards
Frank Kabel
Frankfurt, Germany


J_J wrote:
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