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

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

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

"Frank Kabel" wrote in message
...
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