The autofilter value would be different product types once you select the
product from the combo box I need the quote sheet to be filled with the cost
and the price value from the selected product. The product type is in
column B the price in column E and the cost in column G.

Thanks for the help.

Marc