drop down lists

[RChastain]

I need to have a drop down list that will give me information in three colums.
A B C
1 Part NO Part Disc Part Price
2

When I did a drop down list I could only get one col to work. I need to be able to list all colums so when B1 and C 1 show what the part number is and how much it costs.
thanks
ronnie

 

[Dougie1]

Do a search on this forum for dependent dropdowns.

That will give you all the info you need.

D

 

[RChastain]

Re: drop down lists, product number is a1, prodcut dis a2, product price is a3...how do i use drop down for a 1 and a 2 and a 3 is directly related to a 1.

<TABLE style="WIDTH: 438pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=584 border=0><COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 260pt; mso-width-source: userset; mso-width-alt: 12690" width=347><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><TBODY><TR style="HEIGHT: 78pt; mso-height-source: userset" height=104><TD class=xl73 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; WIDTH: 88pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 78pt; BACKGROUND-COLOR: #c5be97" width=117 height=104>Product Nomber</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 260pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #c5be97" width=347>Product Discription</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 90pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #c5be97" width=120>Prodcut List</TD></TR><TR style="HEIGHT: 21.75pt; mso-height-source: userset" height=29><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 21.75pt; BACKGROUND-COLOR: #dbe5f1" height=29> </TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1"> </TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1"> </TD></TR><TR style="HEIGHT: 21.75pt; mso-height-source: userset" height=29><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 21.75pt; BACKGROUND-COLOR: white" height=29>BMCBD05</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white">Countertop Dry Bun Box for 9 and 11 Roller Grill</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD></TR></TBODY></TABLE>

 

[Dougie1]

http://www.mrexcel.com/forum/showthread.php?t=375803