Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Dropdown list During Data Entry
I have a table Consists of part numbers and prices in two column List.
I have a template that lists all possible items to order. Each list ( Price list and order list are on seperate sheets) The order list consists of Item description/Quantity to order/price When I punch the quantity in this list The VBA code "Knows" which part of the price list to go to BUT This specific part can be supplied by Say 3 suppliers, ALL have a unique suffix Let me expand The part# consists of two parts XX supplier Code, YY part # The parts that can be supplied by several suppliers must use item range XX80 XX99 Also these parts have same number for say the three supplier So if we have 3 supplier providing the SAME part # (with different prices of course); this part is coded 1184/4484/5084 The item number is the same (84) But from different supplier Three Supplier 11, 44, and 50 Where is the Problem ? I need to get to CHOOSE ONE of these suppliers after I punch the quantity to get the correct price based on MY CHOICE OF A SUPPLER Suppose I use Combobox I need to pick the supplier from this list. But since it is a dynamic price list the Template list should reflect the current "suppliers" for that item. In other words if a new supplier for part # 84 with code 9984 I get the name of the supplier(99) added to the combobox. This is, I am sure, beyond me. Of course If I push myluck here and venture not only supplier name but a price so I can choose the cheapest But this is an option. (supplier number or name can be solved by a simple lookup table I hope) PS The combobox is merely a suggestion Sorry for the "wordy" email I am counting on your patience |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic DropDown list from Unsorted vector | Excel Worksheet Functions | |||
Need to have a dropdown list or allow other entry? | Excel Discussion (Misc queries) | |||
Data Validation - Restrict entry but without dropdown | Excel Discussion (Misc queries) | |||
applying dropdown list entry to multple cells | New Users to Excel | |||
Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) |