Forum Discussion
multiple dynamic drop down lists
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.
