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