Forum Discussion
multiple dynamic drop down lists
Maybe I'm thinking too much into this, but could someone point me in the right direction?
I have a file that's over 10 yrs old and needs some updating, needless to say it is beyond my ability and the original person who made it has moved on. Unfortunately I can share it. So I created a quick reference of how I need it to work, let me try to explain the sequence of operations.
1. the user would select the length they want to order from a drop down(60, 72, 84, 96....)this drop down would get the data from sheet2
2. After making the first selection, then the user would select another drop down(split or solid), that only matches from the first length drop down.
3. The user picks these two options(split or solid) it would than populate the appropriate p/n's to choose from.
Anything you can throw me would be great, I've been raking my brain for the past 3 days on this.
10 Replies
- Forgive me, but I still don't understand. I'm just someone who understands a bit about computers, just a bit.
Please explain your plan more precisely. In which column and from which line should the drop down menu be. In which worksheet and which data should be filtered and where should they appear.
Anyway a detailed description would help.
Please consider that I am the ignorant in your job.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)Ok, I see were I went wrong explaining this, my bad. Alright, let me try from the top.
A customer orders an assembly from us that consist of three components (tail + center + tail). These three components are sold in the combined length of all three. so for a 10' I would pick 18"(tail) + 84"(center) + 18" (tail) = 10'(total length). They also have two version's within the tails and centers of split and solid(different part numbers). So what I was hoping to do was as a dropdown's were picked it would remove the part numbers that couldn't be used, ie if you choose 72" all of the other length wouldn't show up in the tail and center drop downs. likewise for the solid and split depending on which one they picked the other would be hidden.
werner77 So you basically want to have some filters. The concept is still the same as what I demonstrated in the previous sheet. You have the user select some drop downs which formulas on the other sheet use to create the desired filtered list and then the part list drop down points at that calculated filtered list. I can't demo it because I still don't see how this works for your situation. I'm not sure if I just don't get it or if it is because you only shared a limited set of data and hence it isn't 'adding' up. But look in that sheet at cell D2 where i create a filtered list based on 1st indexing the area to only return the column based on if it is solid or split, then the FILTER returns only the rows that = the desired length but you will have to do something like >= or <= based on mins or maxs or something.
I hope that puts you on the right track.
Here are some files with drop down examples form the Internet.
You just need to adapt them to your needs.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
I've gotten that, I just need the next (2nd & 3rd) dropdowns to be populated with the data from the first.
werner77 I think I get what you want but don't exactly understand because you say length and split or solid and then part number but I don't get why split/solid is a problem. In any case the secret to creating customized dropdowns dependent on prior selections is to use a helper column. Basically create a formula that will filter the data set(s) based on the prior selection and then have a dropdown based on that filtered list. In the attached I have length drop down and split/solid drop down and then the part number dropdown only shows part numbers that meet those 2 inputs. I hope this example helps.
