Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a combo box to populate rest of a table
I have a table as listed below:
ITEM QTY. UNITS GROUP CATEGORY ALLOWANCE COST Design Costs by Ka Homes Designer 1 EA ? G Drafting Costs 1 EA ? G Duplicating Costs 1 EA ? G Engineering Costs 1 EA ? G Preliminary stake-out 1 EA ? L Site Survey Costs 1 EA ? G Not in Bid / By Owner * Not in Bid / Not Applicable - In another worksheet, I have a combo box that references column A (ITEM). How do I set up the combo box so when I select "Drafting Costs", the column to the right fill in with the corresponding data? The furthest I've gotten is to have only the column to the right of my combo box change, not all of the columns. Thanks Neil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a combo box to populate rest of a table
How about using Data|Validation?
Then you could use a formula like: =if(a1="","",vlookup(a1,sheet2!a:c,2,false)) Debra Dalgleish has some nice instructions at: http://www.contextures.com/xlDataVal01.html for Data|validation and instructions for =vlookup() at: http://www.contextures.com/xlFunctions02.html Neil wrote: I have a table as listed below: ITEM QTY. UNITS GROUP CATEGORY ALLOWANCE COST Design Costs by Ka Homes Designer 1 EA ? G Drafting Costs 1 EA ? G Duplicating Costs 1 EA ? G Engineering Costs 1 EA ? G Preliminary stake-out 1 EA ? L Site Survey Costs 1 EA ? G Not in Bid / By Owner * Not in Bid / Not Applicable - In another worksheet, I have a combo box that references column A (ITEM). How do I set up the combo box so when I select "Drafting Costs", the column to the right fill in with the corresponding data? The furthest I've gotten is to have only the column to the right of my combo box change, not all of the columns. Thanks Neil -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populate combo box | Excel Discussion (Misc queries) | |||
Populate a combo box | Excel Discussion (Misc queries) | |||
Populate List / Combo Box | Excel Discussion (Misc queries) | |||
Populate a combo Box | Excel Worksheet Functions | |||
Populate embedded combo box | Excel Worksheet Functions |