J
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
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