Slicemahn
07-14-2008, 04:57 AM
Hello Everyone!
This problem I hope someone can solve because I am frustrated. What I am trying to do is use three drop down boxes as criteria to pull info from an underlying spreadsheet.
This is how it is supposed to work: If a certain VP is selected then in the corresponding Directors would be revealed in the next drop-down box. Subsequently when a director is selected then correspoonding Team Manager would be revealed in the third drop down box.
I have attached my spreadsheet to this post. I having been using a combination of data validation and named ranges to pull this one off but to no success.
Please let me know your thoughts.
This problem I hope someone can solve because I am frustrated. What I am trying to do is use three drop down boxes as criteria to pull info from an underlying spreadsheet.
This is how it is supposed to work: If a certain VP is selected then in the corresponding Directors would be revealed in the next drop-down box. Subsequently when a director is selected then correspoonding Team Manager would be revealed in the third drop down box.
I have attached my spreadsheet to this post. I having been using a combination of data validation and named ranges to pull this one off but to no success.
Please let me know your thoughts.