Hello -
Have a wide variety of values in column B. For each value in Column B, there should either be a drop-down list unique to that value or a blank. I am trying to use an if formula to return the appropriate drop-down list depending on the value in column B. For instance, if value in cell B2 = "Quality", return a list that includes: QA, QC.
A) Is this feasible? B) How do I do it
Many thanks,
bRob
Create multiple linked dropdown list in excel
http://helpdeskgeek.com/office-tips/...ists-in-excel/
http://thefinch.wordpress.com/2008/0...datavalidatie/
http://www.contextures.com/xlDataVal02.html
http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch
I can't help you enough with VBA.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Have you seen this thread? I'm not sure exactly what you want but this seems pretty similar.
http://www.excelforum.com/excel-prog...combobox1.html
maybe you need to extract all the unique names from your list 1st, and then use that list to create the drop-downs that you want?
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
Thanks oeldere!
That hit the spot.
-bRob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks