View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KG121953 KG121953 is offline
external usenet poster
 
Posts: 6
Default Drop down Box / Functions

HELP Please
This is what I would like to do...
Example:
"C6" is a drop down menu for design type Designs are listed as 4000, 6000,
3500...Each have a deferent price/per that needs up dating
I don't want to put in cost every time I price out a job. I would like
"4000" in the drop down menu to refer to cell "G15" where the price / per is
entered when price is updated
So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9
(C9 amount of)
6000 would be "G16", 3500 "G17....