Kids furniture inventory

strangedenial

New Member
Joined
Sep 15, 2014
Messages
39
Hi all,
I'm pretty sure this one is really a piece of cake but somehow I can not get it all together and find a solution
Let's say that I have a product , which is a car-bed.
The product has these vars :

- Product code
- Sizes
- Colors
- Brands
- Price (which depends on the size and options)
- Option 01
- Option 02

So I'm giving 3 products as an example

Brand: BMW
which has these vars
Colors : Red (Product code: B01) , Blue (Product code: B02), White (Product code: B03)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $)Size 03 (30 $) Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)

Brand: Ferrari
which has these vars
Colors : Green (Product code: F01), Blue (Product code: F02), Red (Product code: F03), Yellow(Product code: F04)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $)Size 03 (30 $) Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)

Brand: Audi
which has these vars
Colors : Black (Product code: A01), White (Product code: A02), Yellow (Product code: A03), Blue (Product code: A04)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $)Size 03 (30 $) Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)


So what do I need ?


cell C02 - drop down 1 - will have a list of all Brand Names of that product. (in example only 3 but in real a lot more)
cell D02 - drop down 2 - will have all the available colors of the chosen brand in drop down 1
cell E02 - drop down 3 - will have all available sizes
cell F02 - Check box - will be the Option 01 (+10$)
cell G02 - Check box - will be the Option 02 (+20$)
cell H02 - price without options (chosen size from drop down 3)
cell I02 - price of total chosen options
cell J02 - Total price


I'm not pretty sure if I was clear enough, if you don't understand clearly what I need, please ask me to explain it more detailed.
Thanks in advance!!!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,114,111
Messages
5,546,000
Members
410,720
Latest member
SSL
Top