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