• Creator
  • #2158577

    Need help creating dependant lists in excel…


    by andrew.petry ·

    I have a bit of a problem. I’m needing to make an excel spread with dropdown lists that will display the total prep time of a machine when it is selected from a list. For example…I want to be able to select a Manufacturer from a list, then on a second list display the model, and then another list with a selection of implements (ie bucket install, auger, ect) each adding an additional increment of time to the base prep of the machine. Some machines can have multiple implements also which all need to be able to be added together to give a total prep time and the dollar amount that prep time will cost sales. Prep time is in hours and we multiply hours by $57.00 to get our cost. Is this even possible in excel? Please help!


All Answers

Viewing 2 reply threads