Hi All,
I have a list of of Departments and Manager Heads. I want to create a custom drop down using the data validation list feature, but have it be custom on a cell value.
For example, I put in Manager 1 in cell A1. I want A2 to feature any departments (in a dropdown) that manager might be the head of.
Is this possible?
Yes it is, it uses a dependent drop-down, see that attached and let me know if you can adapt it to your needs.
It uses named ranges for each level and sublevel, and then uses INDIRECT
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks