Question

  • Creator
    Topic
  • #2158577

    Need help creating dependant lists in excel…

    Locked

    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!

    Thanks
    Andrew

All Answers

Viewing 2 reply threads