Hi can someone help me in the best way to do what I'm trying to achieve.
I want a set of drop lists to filter based on the previous selection. So using the example data below I want to be able to select a product, then the next drop down list is to be able to select a quantity based on the previous with a final cell entering the defined unit cost.
<tbody>
</tbody>
Example:
I want Flyer A5 then to select 500 and it will automatically input the unit cost in the 3rd cell.
<tbody>
</tbody>
Any help is appreciated.
I want a set of drop lists to filter based on the previous selection. So using the example data below I want to be able to select a product, then the next drop down list is to be able to select a quantity based on the previous with a final cell entering the defined unit cost.
Product: | Quantity | Unit Cost | |||
Flyer A6 | 100 | £30.00 | |||
Flyer A6 | 250 | £36.00 | |||
Flyer A5 | 500 | £42.00 | |||
Flyer A4 | 1000 | £50.00 | |||
2000 | £63.00 | ||||
5000 | £140.00 | ||||
Flyer A5 | 100 | £30.00 | |||
250 | £42.00 | ||||
500 | £62.00 | ||||
1000 | £73.00 | ||||
2000 | £125.00 | ||||
5000 | £260.00 | ||||
Flyer A4 | 100 | £40.00 | |||
250 | £61.00 | ||||
500 | £95.00 | ||||
1000 | £160.00 | ||||
2000 | £245.00 |
<tbody>
</tbody>
Example:
I want Flyer A5 then to select 500 and it will automatically input the unit cost in the 3rd cell.
Product | Quantity | Unit cost |
Flyer A5 | 500 | £62.00 |
<tbody>
</tbody>
Any help is appreciated.