Can this work???

[Guest]

I want to take a column and put my tech's names in a drop list format. the
problem is, I have a lot of techs, therefore a lot of scrolling through that
list and wasting time. So i've added a column of their management areas, each
management area has roughly ten techs. I have made a drop list for each
management area So here is what I am proposing to do, if I have the
management area of the tech already added to a cell, can I use that to switch
between drop lists, if I can can you clue me in as to how???? If I wasn't
clear please let me know I'll post again. Thank you very much

 

[Ed]

Try looking here to see if it has what you need:
http://www.contextures.com/xlDataVal01.html. This first page explains
making drop-down lists using Data Validation. The second page explains
making two drop-downs, with the second dependant on the first.

Ed

 

[Guest]

At the address below, you'll find a very good tutorial on how to create
drop-down lists in cell using Named Ranges and Data Validation features of
excel. Then, at the end, the next tutorial will show you how to makes
dependents lists which is what you are looking for.
http://www.contextures.com/xlDataVal01.html

Regards,
Sebastien

 

[Guest]

I did everything like I was supposed to and then when I had to name the
groups to reference them I found out that my management areas with names like
5j and 6i had names that weren't valid is there any way around that? thank
you for your help.

 

[Guest]

I did everything like I was supposed to and then when I had to name the
groups to reference them I found out that my management areas with names like
5j and 6i had names that weren't valid is there any way around that? thank
you for your help.

 

[Guest]

To name ranges, instead of using the Name box, use the menu: Insert > Name >
Define. There, if you enter an invalid name, it will tell you while the name
box doesn't tell you in some situations.

Regards,
Sebastien