Dynamicly Building Drop Downs / Filters

Snowboyd

New Member
Joined
Oct 9, 2014
Messages
3
Hi there

I have a problem that I can't figure out

I have a largeish list of products in a table with initial rows for Category, Agreement Type, Product and Product Ref. In the following rows there is information specific to the product on that agreement type such as Target Price, Contract Length and Minimum Price

I want to be able to build orders of multiple products on sepearate rows on a form so:

On the first line I drop down the Category and Service Type which will massively reduce the list in the drop down for Product.

Once I select the Product then Product Ref, Target Price, Contract Length and Minimum Price are to be returned in the following rows.

So data looks like this

Product Category Name

<tbody>
</tbody><colgroup><col></colgroup>
Agreement Type Name

<tbody>
</tbody><colgroup><col></colgroup>
Product Name

<tbody>
</tbody><colgroup><col></colgroup>
Product Ref

<tbody>
</tbody><colgroup><col></colgroup>
Target Price

<tbody>
</tbody><colgroup><col></colgroup>
Contract Length

<tbody>
</tbody><colgroup><col></colgroup>
Minimum Price

<tbody>
</tbody><colgroup><col></colgroup>
Hatchback

<tbody>
</tbody><colgroup><col></colgroup>
Sale

<tbody>
</tbody><colgroup><col></colgroup>
Focus

<tbody>
</tbody><colgroup><col></colgroup>
100001

<tbody>
</tbody><colgroup><col></colgroup>
14000

<tbody>
</tbody><colgroup><col></colgroup>
0

<tbody>
</tbody><colgroup><col></colgroup>
11000

<tbody>
</tbody><colgroup><col></colgroup>
Hatchback

<tbody>
</tbody><colgroup><col></colgroup>
Rental

<tbody>
</tbody><colgroup><col></colgroup>
Focus

<tbody>
</tbody><colgroup><col></colgroup>
100001

<tbody>
</tbody><colgroup><col></colgroup>
2000

<tbody>
</tbody><colgroup><col></colgroup>
3

<tbody>
</tbody><colgroup><col></colgroup>
1500

<tbody>
</tbody><colgroup><col></colgroup>
Hatchback

<tbody>
</tbody><colgroup><col></colgroup>
Service

<tbody>
</tbody><colgroup><col></colgroup>
Focus

<tbody>
</tbody><colgroup><col></colgroup>
100001

<tbody>
</tbody><colgroup><col></colgroup>
3500

<tbody>
</tbody><colgroup><col></colgroup>
3

<tbody>
</tbody><colgroup><col></colgroup>
2000

<tbody>
</tbody><colgroup><col></colgroup>
City

<tbody>
</tbody><colgroup><col></colgroup>
Rental

<tbody>
</tbody><colgroup><col></colgroup>
Corsa

<tbody>
</tbody><colgroup><col></colgroup>
100003

<tbody>
</tbody><colgroup><col></colgroup>
1500

<tbody>
</tbody><colgroup><col></colgroup>
5

<tbody>
</tbody><colgroup><col></colgroup>
1000

<tbody>
</tbody><colgroup><col></colgroup>
City

<tbody>
</tbody><colgroup><col></colgroup>
Service

<tbody>
</tbody><colgroup><col></colgroup>
Corsa

<tbody>
</tbody><colgroup><col></colgroup>
100003
2000

<tbody>
</tbody><colgroup><col></colgroup>
5

<tbody>
</tbody><colgroup><col></colgroup>
1500

<tbody>
</tbody><colgroup><col></colgroup>
Hatchback

<tbody>
</tbody><colgroup><col></colgroup>
Sale

<tbody>
</tbody><colgroup><col></colgroup>
Astra

<tbody>
</tbody><colgroup><col></colgroup>
100008
13000

<tbody>
</tbody><colgroup><col></colgroup>
0

<tbody>
</tbody><colgroup><col></colgroup>
10000

<tbody>
</tbody><colgroup><col></colgroup>
Hatchback

<tbody>
</tbody><colgroup><col></colgroup>
Service

<tbody>
</tbody><colgroup><col></colgroup>
Astra

<tbody>
</tbody><colgroup><col></colgroup>
100008
3500

<tbody>
</tbody><colgroup><col></colgroup>
3

<tbody>
</tbody><colgroup><col></colgroup>
1500

<tbody>
</tbody><colgroup><col></colgroup>

<tbody>
</tbody>

(plus 400 odd rows!)

Thanks
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Snowboyd

New Member
Joined
Oct 9, 2014
Messages
3
Hi
Thanks but filters won't do the job as I want to create several rows (so row on the order could be for a Focus with a certain spec, the next row may be for another Focus with a slightly different spec)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,462
Messages
5,528,950
Members
409,848
Latest member
Blomsten
Top