I would like assistance with creating several filters that act as a drill down. In the workbook that I am attaching all of the data resides on the PrSchTab. I would like to take the data from the PrSchTab and be able to use to filter for information in the Production Source area on the Schedule Calc tab.
Starting with column labeled Brand, once the brand is selected would only like to see the Type that is associated with the brand this can include blanks. Once the Type is selected would then only like to see the Partner (field can be blank) then from there the Factory and Location can be selected, however these are dependent on the category which is hard coded into the Production Source calculator Lines D16:D2.
The end result is to get the Production Lead TIme number so that a date can be calculated and populated in column G on Schedule Calc Tab
I have comments on the attached workbook.
Please let me know if there are additional questions.