Forum Discussion
DROP DOWN BOX
HI,
IM FAMILIAR TO EXCELL BUT STILL NEWER TO EXCELS FURTHER ADVANCED OPTIONS.
WHAT I AM TRYING TO GET IS A DROP DOWN BOX WHERE I CAN CHOOSE A PRODUCT NAME AND IT WILL PUT THE TOTAL PRICE IN BASED OFF FROM THE COST IN A SEPERATE BOX.
AN EXAMPLE IS
ANY IDEAS WOULD BE HELPFUL
THANK YOU
BECCA
| CABINET COST | COST FOR TYPE OF CABINETS SOLD | FREIGHT | |
| HUNTWOOD | $4,000.00 | $1,440.00 | $215.00 |
| DURASUPREME | $4,000.00 | $1,680.00 | $100.00 |
| WAYPOINT | $4,000.00 | $1,480.00 | $100.00 |
| CROWN | $4,000.00 | $1,920.00 | $250.00 |
|
<- THIS BOX SHOULD HAVE THE 1440.00 PRICE IN IT AFTER I SELECT HUNTWOOD OR WHICH EVER SUPPLIER FROM DROP DOWN LIST |
|||
|
|
<- THIS BOX SHOULD HAVE 215.00 IN IT AFTER SELECTING FREIGHTHW OR ALSO DEPENDING ON SUPPLIER SELECTED FROM DROP DOWN BOX |
||
2 Replies
Hi Becca Zarnik,
Is this the sort of thing you need (see attached file). If so then I'm happy to explain how it works
test...
