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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
Forgot to mention I am using Excel 2007 on XP Pro
"WDrummond" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
By "external" do you mean that the master source is a different excel
file, or an access file? If you pick two things e.g. type of equipment and then a list of something associated with what was selected only to get a quote returned, it would be super easy to do (I'd probably put that $ value in a cell, not a box - or else run the whole thing in a userform). I've done something else really similar to this with an Access database and a bunch of drop-down comboboxes ... please just clarify where your source data is. Chris On Mar 10, 11:04*am, WDrummond wrote: Forgot to mention I am using Excel 2007 on XP Pro "WDrummond" wrote: 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- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
I would prefer it in a seperate Excel file but Access would work as well.
To hopefully simplify it more for the part Im working on now I want 3 boxes. The first I want a drop down list from an external workbook preferably. (So they can pick Network devices, controllers, Sensors...ect.) The second I want another drop down list from an external workbook preferably based on the first. (That way if the pick network devices it will only have those devices rather than all devices) the third is the price from and external workbook preferably. The basis or reason for this is so we have a central point to edit the lists of devices and prices. It is not easy to get what I want in my head onto paper as words but I hope this helps. Thanks, Wayne "cht13er" wrote: By "external" do you mean that the master source is a different excel file, or an access file? If you pick two things e.g. type of equipment and then a list of something associated with what was selected only to get a quote returned, it would be super easy to do (I'd probably put that $ value in a cell, not a box - or else run the whole thing in a userform). I've done something else really similar to this with an Access database and a bunch of drop-down comboboxes ... please just clarify where your source data is. Chris On Mar 10, 11:04 am, WDrummond wrote: Forgot to mention I am using Excel 2007 on XP Pro "WDrummond" wrote: 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- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
I'm putting something together for you right now ...
Chris On Mar 10, 12:12 pm, WDrummond wrote: I would prefer it in a seperate Excel file but Access would work as well. To hopefully simplify it more for the part I'm working on now I want 3 boxes. The first I want a drop down list from an external workbook preferably. (So they can pick Network devices, controllers, Sensors...ect.) The second I want another drop down list from an external workbook preferably based on the first. (That way if the pick network devices it will only have those devices rather than all devices) the third is the price from and external workbook preferably. The basis or reason for this is so we have a central point to edit the lists of devices and prices. It is not easy to get what I want in my head onto paper as words but I hope this helps. Thanks, Wayne "cht13er" wrote: By "external" do you mean that the master source is a different excel file, or an access file? If you pick two things e.g. type of equipment and then a list of something associated with what was selected only to get a quote returned, it would be super easy to do (I'd probably put that $ value in a cell, not a box - or else run the whole thing in a userform). I've done something else really similar to this with an Access database and a bunch of drop-down comboboxes ... please just clarify where your source data is. Chris On Mar 10, 11:04 am, WDrummond wrote: Forgot to mention I am using Excel 2007 on XP Pro "WDrummond" wrote: 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- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with external drop down lists
Wayne, can you send me an email address I can send my work to? Thanks!
cht13er @ gmail. com On Mar 10, 9:51 pm, cht13er wrote: I'm putting something together for you right now ... Chris On Mar 10, 12:12 pm, WDrummond wrote: I would prefer it in a seperate Excel file but Access would work as well. To hopefully simplify it more for the part I'm working on now I want 3 boxes. The first I want a drop down list from an external workbook preferably. (So they can pick Network devices, controllers, Sensors...ect.) The second I want another drop down list from an external workbook preferably based on the first. (That way if the pick network devices it will only have those devices rather than all devices) the third is the price from and external workbook preferably. The basis or reason for this is so we have a central point to edit the lists of devices and prices. It is not easy to get what I want in my head onto paper as words but I hope this helps. Thanks, Wayne "cht13er" wrote: By "external" do you mean that the master source is a different excel file, or an access file? If you pick two things e.g. type of equipment and then a list of something associated with what was selected only to get a quote returned, it would be super easy to do (I'd probably put that $ value in a cell, not a box - or else run the whole thing in a userform). I've done something else really similar to this with an Access database and a bunch of drop-down comboboxes ... please just clarify where your source data is. Chris On Mar 10, 11:04 am, WDrummond wrote: Forgot to mention I am using Excel 2007 on XP Pro "WDrummond" wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
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 |