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!


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Better way

by unhappyuser In reply to Need help creating depend ...

Use Access and create a database with forms. It will be much easier to track and a lot easier getting decent-looking reports.


Collapse -

I don't have access

by andrew.petry In reply to Better way

Unfortunately we don't have Access here (I All I'm wanting to do is make sheet where the guys in sales can click and select a make, next col click to select model, next col click to select any additional implements on the machine, then to the right of that I need the total prep time it'll take to set that machine up with a dollar amount (hours*$57.00). I've got something started that looks promising (as far as drop downs are concerned) but I haven't done anything with numbers. Just dependant lists. Can you help?!


Collapse -

I've got that much

by andrew.petry In reply to some examples

I've already got all the drop downs made that i'm going to need. I just need to associate a number with each selection ending with the adding of all those numbers at the end. Any help as to how I could do that?


Related Discussions

Related Forums