Hi all,

I have an urgent problem with no solution. I run a workbook listin
machinery. The machine may take on around 10 configurations.

What i am looking to achieve, is use a combo box to list the machines
When the machine is selected the correpsonding price for the option
listed fill in column D. These options fill column A and there ar
about 50 of them. The price for each is dependant on the machine chose
and all prices are listed on the next sheet.

To summarise:

1. user selects machine from combo box
2. correpsonding options price then copies from sheet2 to matchin
option in column D

ppplleeeeaassseee....help!!!! Im needing something today!!

--
Message posted from http://www.ExcelForum.com