combo box problem I am pulling my hair out about!!!!
I really hope someone can help me....
I am creating a quote form. It is for a roofing company and I want to be able to create a combo box which lets me select an item, and then in an adjacent column bring up the dollar value for that selected item. ie. MATERIAL AMOUNT COST TOTAL Colorbond 10m² $25 $250 Under 'Material' I want a list or combo box to select items from. When I select an item, I want the cost of it to show under the 'cost' column. How can I do this? Please help... Terry |
Tinker around with this ..
First, set-up the Material - Unit Cost table below in Sheet2, in A2:C4 1 Colorbond 25 2 WP_Paint 20 3 Tile Type A 50 In Sheet1 ------------ Assume A1:D4 houses the headers: Material, Amt, Cost, Total Draw a combo box (from the Forms Toolbar) over cell A2 Right-click on it Format Control Put in: Input range: Sheet2!$B$2:$B$4 Cell link: $A$2 Click OK Put in C2 (under "Cost"): =VLOOKUP(A2,Sheet2!$A$2:$C$4,3,0) Test out the combo box .. Select "Colorbond", C2 will return: 25 Select "WP_Paint", C2 will return: 20 And so on .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "TerryStyles" wrote in message ... I really hope someone can help me.... I am creating a quote form. It is for a roofing company and I want to be able to create a combo box which lets me select an item, and then in an adjacent column bring up the dollar value for that selected item. ie. MATERIAL AMOUNT COST TOTAL Colorbond 10m² $25 $250 Under 'Material' I want a list or combo box to select items from. When I select an item, I want the cost of it to show under the 'cost' column. How can I do this? Please help... Terry |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com