Hi,
I am pretty new to excel so go easy on me!
I have created a series of dropdown lists that have hundreds of options but the variables are linked. For instance; if i selected a diameter of 190mm (out of 200 different possibilities) from one of the dropdown lists, there are only 15 heights that can correspond to that diameter however the height list will still show 300 different heights.
WHAT I WANT TO DO: when you select a height from the dropdown it only allows the corresponding diameters to be shown in the next list, not every diameter in the system.
Thank you in advance for the help - much appreciated.
Best Regards,
Chris
Bookmarks