Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
I have been working to make some drop down list but I have been unsuccessful
so far. I figured I would let you all know what I am trying to do and see if I am approaching this the wrong way. What I want is to have a Excel workbook for Quotes. In this workbook I want to have a drop down list that will allow someone to pick a type of equipment. Then I want a second drop down list that will be varied based on what was picked in the first drop down list. Finally I want a price place in a third box based on the second drop down list. Sounds easy enough but here is the twist and the hard part. The drop down list source needs to be external because there are many changes that happen to it regularly so we need to be able to go to one central location and change a price or add a entry to the list so it will affect the quotes when they are opened rather than having to change each quote individually which would be virtually impossible. Thanks for any help and feel free to ask any question that I can answer to help define the problem. Wayne Drummond |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |