PDA

View Full Version : how to associate a drop down box to multiple equations



JDKrause1169
10-29-2019, 02:53 PM
I am relatively new using VBA. The attached is an excel workbook where I need to associate the drop down boxes ("description"),in the worksheet PL Case. I would like to attribute the following columns (IE:)

Drop down descriptions each one will give you the information to generate pricing.

"Type of cabinets" Unit Qty Wide High Dp/th Other

Then in Materials, Buyou, Mac, Ben, Fin, Eng, Inst., Matl & Labor will generate the answers:
(All these already have specific formulas)

With GC and Unit Pricing

Then I need it to lock into the Summary worksheet

JonathanOne
11-26-2020, 02:52 AM
To be honest, the answer to your question can be found in Google. At your request - the first link. And then you will figure it out. Good luck