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

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

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

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

"cherrynich" wrote:

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

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.

"cherrynich" wrote:

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

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.


"Ed" wrote:

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

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

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

"cherrynich" wrote:

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.

"cherrynich" wrote:

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