I need help creating a dashboard that contains 3 Combobox's that then cascades through selection down to the resulting machines test results.
EX: Bulldozer > John Deere > 750K or Excavator > CAT > D264
My excel workbook is comprised of Multiple sheets for every type of construction machine. EX. Bulldozer Info, Excavator Info, Ex. Each sheet has a table with Brand, Model, Weight, Test Results etc. Im trying to create a dashboard that allows the person to select the machine type, brand, model, then the test results are shown below. I got the second combobox to provide the proper brand being dependent of the Machine, but there are still multiple duplicates. Last I have no idea how to connect the last combobox (Model) to be specific to the machine and brand to show the proper model in the vba code (Model Column in Each Sheet). It also has to allow for more machines in the other tables to be added without having to modify the code. When I get to the model im going to set a Vlookup so I know how to get the pass/fail information. If anyone has any recomendations on how to do this or an alternative I would greatly appriciate it.
Bookmarks