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