Drop down menu modifying cells with multiple dependencies

sk8erboi82

New Member
Joined
Sep 26, 2014
Messages
1
Hello,
I deal with different cable and need to create a sheet which would help to chose how to equip the cables with the right accessories (pins, boots and liners). I need to create a drop down list for the cable types and auto populate the cells for Pins, boots and liners depending on the cable chosen from the drop down menu.


The selection of pins depends on the wire gauge, liners on insulators OD.

What is the best (easiest) way to do it?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,060
Members
409,682
Latest member
HisHailo

This Week's Hot Topics

Top