I am trying to create a calculator that will return dates based on selecting criteria. I've tried the cascading drop down methods but I am not able to get the second criteria to pull in the drop down. Also sure if this is the best way to go about getting the information that I need.
I am attaching a copy of my workbook. The area that I am working on is the Production Sources. I would like to select the Brand, Type and Partner. How I envision the drop down working is once the Brand is selected, would see only the Type and Partner available for the Brand, Then only the factory locations and vendors for the brand as well. Is this possible to do? and Is it possible to get a unique list of values?