Roll down - automatically fill in

MS Excel 2007:

I work in sales and I'd like to have an easy way to make the offer as I speak to the costumer.

My starting point is a price list, where Column A is category, B is product, C is placement and D is price.

What I'd like my worksheet to do is the following.

I'd have two roll down menus, let's say they are placed in A2 and B2. The first one is "Category". When selecting a category in the first roll down, the second roll down ("Product" will change based on the category selection. When a product is selected, cell C2 and D2 automatically fills inn the placement and price.

Is there any way to do this without having to re-write the whole price list?

-Marovic

Hi Steffen,

I've made an excample of what I want, and attatched it to this post.
(Can't upload the original price list, for obvious reasons)

Sheet 1 is called "Model", and sheet 2 is called "Price list", where I want the model to collect the data from.

I get a bug. First, when opening the worksheet i get a run-time error: '1004' saying that it didn't fint any cells. Pressing debug brings up the Visual Basic, and as you can see from the screenshot attatched one line is marked in yellow.

The set up is a bit different from what I initially wanted, but if we could get this to work it would be awesome :-)

That's great!

Thank you! Much appreciated! I'll come back if I have further questions later on :-)