VBA to show data from a dropdown box selection

[alibbye17]

I’ll try and be as detailed as possible.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Im trying to set up a calculator to compare like products from a different company. Within a drop down box I have a list of our competitors products (5 products but each product has different variations that roll into it). Once a user selects a product from the drop down list I would like the different variations of that product (from the competitor) to appear to the right of the selection. <o></o>
<o> </o>
Currently I have a list of the competitor products in Columns H through AD. The product are defined in column H. The columns that follow “H” relate to price, margin, etc… <o></o>
<o> </o>
The drop down list can be found in cell b8. The items within this list are Zoom, Max, Marathon, Verse, Hurl. These are the same product labels that can be found in column H above.<o></o>

 

[VoG]

Perhaps this http://www.contextures.com/xlDataVal02.html

 

[alibbye17]

Once a user selects a product from the drop down list I would like the different variations of that product (from the competitor) to appear to the right of the selection.

What Im trying to do is have an individual select one item from a drop down box (no other selections are neccessary). Once the selection is made the corresponding data will be shown to the right of cell b8. If the selection is changed to a diffrent product then once again the correlating data will be shown to the right of cell b8.

 

[alibbye17]

This has been solved. Thanks