I have a simple spreadsheet that looks like the following...
<tbody>
</tbody>
I wanted to have the ability to have a dynamic list generated where the user chooses a product (via a dropdown list called "Portfolio" and a list generates where it will give the list of the Item Number and number associated with it. Like...
Product 2
Item 1 1.4%
Item 2 5.6%
Item 5 2.1%
Product 4
Item 2 7.7%
Item 4 1.2%
Is this possible and how would I tackle this?
Cheers,
Guy
| Product 1 | Product 2 | Product 3 | Product 4 | |
| Item 1 | 1.4% | 1.4% | 1.4% | |
| Item 2 | 5.6% | 7.7% | ||
| Item 3 | 6.7% | |||
| Item 4 | 1.2% | |||
| Item 5 | 2.1% | |||
| Item 6 | 5.5% |
<tbody>
</tbody>
I wanted to have the ability to have a dynamic list generated where the user chooses a product (via a dropdown list called "Portfolio" and a list generates where it will give the list of the Item Number and number associated with it. Like...
Product 2
Item 1 1.4%
Item 2 5.6%
Item 5 2.1%
Product 4
Item 2 7.7%
Item 4 1.2%
Is this possible and how would I tackle this?
Cheers,
Guy
