Dependent Drop Down List help

[GregStoner66]

I want to do a dependent drop-down list in which the available items are based on the category selection.

LABOR TAKE OFF.xlsm
	A	B
2	Category	Item
3	Sprinkler Rough-in
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
A3	List	=FieldCategory

Sprinkler Rough-in	Wet Exposed Pipe-Area 1
Sprinkler Rough-in	Wet Exposed Pipe-Area 2
Sprinkler Rough-in	Wet Exposed Pipe-Area 3
Sprinkler Rough-in	Dry Exposed Pipe-Area 1
Sprinkler Rough-in	Dry Exposed Pipe-Area 2
Sprinkler Rough-in	Dry Exposed Pipe-Area 3
Sprinkler Rough-in	Wet Concealed Pipe-Area 1
Sprinkler Rough-in	Wet Concealed Pipe-Area 2
Sprinkler Rough-in	Wet Concealed Pipe-Area 3
Sprinkler Rough-in	Dry Concealed Pipe-Area 1
Sprinkler Rough-in	Dry Concealed Pipe-Area 2
Sprinkler Rough-in	Dry Concealed Pipe-Area 3
Sprinkler Rough-in	Cut Drop
Sprinkler Rough-in	Center Head
Sprinkler Rough-in	Install Flex
Sprinkler Rough-in	Cut cap make safe
Sprinkler Rough-in	Replace
Sprinkler Rough-in	Head Guards
Sprinkler Rough-in	Head Cab &Wrench
Sprinkler Rough-in	Heat Collector
Schedule 40 Pipe	1/2" Pipe
Schedule 40 Pipe	3/4" Pipe
Schedule 40 Pipe	1" Pipe
Schedule 40 Pipe	1 1/4" Pipe
Schedule 40 Pipe	1 1/2" Pipe
Schedule 40 Pipe	2" Pipe
Schedule 40 Pipe	2 1/2" Pipe
Schedule 40 Pipe	3" Pipe
Schedule 40 Pipe	4" Pipe
Schedule 40 Pipe	5" Pipe
Schedule 40 Pipe	6" Pipe
Schedule 40 Pipe	8" Pipe
Schedule 40 Pipe	10" Pipe
Schedule 10 Pipe	1 1/4" S10 Pipe
Schedule 10 Pipe	1 1/2" S10 Pipe
Schedule 10 Pipe	2" S10 Pipe
Schedule 10 Pipe	2 1/2" S10 Pipe
Schedule 10 Pipe	3" S10 Pipe
Schedule 10 Pipe	4" S10 Pipe
Schedule 10 Pipe	6" S10 Pipe
Schedule 10 Pipe	8" S10 Pipe
Schedule 10 Pipe	10" S10 Pipe
Galv Sch 40 Pipe	1" Pipe
Galv Sch 40 Pipe	1 1/4" Pipe
Galv Sch 40 Pipe	1 1/2" Pipe
Galv Sch 40 Pipe	2" Pipe
Galv Sch 40 Pipe	2 1/2" Pipe
Galv Sch 40 Pipe	3" Pipe
Galv Sch 40 Pipe	4" Pipe
Galv Sch 40 Pipe	5" Pipe
Galv Sch 40 Pipe	6" Pipe
Galv Sch 40 Pipe	8" Pipe
Galv Sch 40 Pipe	10" Pipe
Hangers	Small Riser Cl. & Slv.
Hangers	Large Riser Cl. & Slv.
Hangers	Pipe Stand
Hangers	Firestop(UL4991?)
Hangers	Pipe ID
Hangers	Seismic Bracing
Hangers	Seismic Cabling
OS&Y Control Valves	1" OS&Y
OS&Y Control Valves	1 1/4" OS&Y
OS&Y Control Valves	1 1/2" OS&Y
OS&Y Control Valves	2" OS&Y
OS&Y Control Valves	2 1/2" OS&Y
OS&Y Control Valves	3" OS&Y
OS&Y Control Valves	4" OS&Y
OS&Y Control Valves	5" OS&Y
OS&Y Control Valves	6" OS&Y
OS&Y Control Valves	8" OS&Y
OS&Y Control Valves	10" OS&Y
OS&Y Control Valves	12" OS&Y
Misc Control Valves	2.5 Field Adj PRV
Misc Control Valves	2.5" Grv B'Fly
Misc Control Valves	3" Grv B'Fly
Misc Control Valves	4" Grv B'Fly
Misc Control Valves	6" Grv B'Fly
Misc Control Valves	8" Grv B'Fly
Misc Control Valves	1" Butterball
Misc Control Valves	1 1/4"Butterball
Misc Control Valves	1 1/2"Butterball
Misc Control Valves	2" Butterball
Misc Control Valves	Control-T&D Assy
Misc Control Valves	2" ZCA
Misc Control Valves	2.5" ZCA
Misc Control Valves	2.5" ZCA w PRV
Misc Control Valves	4 Fl ZCA
Check Valves	1 1/2" Swing Chk
Check Valves	2" Swing Chk
Check Valves	2 1/2" Swing Chk
Check Valves	3" Swing Chk
Check Valves	4" Swing Chk
Check Valves	5" Swing Chk
Check Valves	6" Swing Chk
Check Valves	8" Swing Chk
Check Valves	2 1/2" Vic Check
Check Valves	3" Vic Check
Check Valves	4" Vic Check
Check Valves	6" Vic Check
Check Valves	8" Vic Check
Misc. Valves & Equip	4" Detector Chk
Misc. Valves & Equip	6" Detector Chk
Misc. Valves & Equip	8" Detector Chk
Misc. Valves & Equip	4" DDC with OS&Y
Misc. Valves & Equip	6" DDC with OS&Y
Misc. Valves & Equip	8" Ames 2000SS w/ OS&Y
Misc. Valves & Equip	By-Pass Meter
Misc. Valves & Equip	4" Wall Valve
Misc. Valves & Equip	6" Wall Valve
Misc. Valves & Equip	8" Wall Valve
Misc. Valves & Equip	Wall Post Ind
Misc. Valves & Equip	4"CLA-VAL -90G21
Misc. Valves & Equip	6"CLA-VAL -90G21
Misc. Valves & Equip	3/4" CLA-VAL 55L-60 RELIEF VA
Misc. Valves & Equip	Jumbo Cut In
Sprinkler Valves	4" Alarm Valve
Sprinkler Valves	6" Alarm Valve
Sprinkler Valves	8" Alarm Valve
Sprinkler Valves	2.5" Dry Valve
Sprinkler Valves	3" Dry Valve
Sprinkler Valves	4" Dry Valve PT
Sprinkler Valves	6" Dry Valve
Sprinkler Valves	3" DI Pre-Ac Va, P-E
Sprinkler Valves	4" DI Pre-Ac Va, P-E
Sprinkler Valves	6" DI Pre-Ac Va, P-E
Sprinkler Valves	3" Deluge Va, Elec R
Sprinkler Valves	4" Deluge Va, Elec R
Sprinkler Valves	6" Deluge Va, Elec R
Sprinkler Valves	3" SI Pre-AC, Elec
Sprinkler Valves	4" SI Pre-AC Pneu
Spkr Alarm & Elec Devices	Water Motor Gong
Spkr Alarm & Elec Devices	D-2 Accelerator
Spkr Alarm & Elec Devices	Air Compressor
Spkr Alarm & Elec Devices	Air Maint Device
Spkr Alarm & Elec Devices	Waterflow Switch
Spkr Alarm & Elec Devices	Electric Bell
Spkr Alarm & Elec Devices	Low Air Switch
Spkr Alarm & Elec Devices	Pressure Switch
Spkr Alarm & Elec Devices	Tamper Switch
Spkr Alarm & Elec Devices	Detectors
Spkr Alarm & Elec Devices	Detection Control Pnl
Spkr Alarm & Elec Devices	Low Air Panel
Spkr Alarm & Elec Devices	Panel VFR400
Spkr Alarm & Elec Devices	SOLENOID VLV, 24VDC
Drains & Spkr Connections	2" Drain ACV-DPV
Drains & Spkr Connections	2" AGF T&D w/Relief
Drains & Spkr Connections	1-1/4" AGF T&D w/Relief
Drains & Spkr Connections	1" AGF T&D w/Relief
Drains & Spkr Connections	2" Aux Drain
Drains & Spkr Connections	1 1/4" Aux Drain
Drains & Spkr Connections	1" Aux Drain
Drains & Spkr Connections	Drum Drip Conn
Drains & Spkr Connections	AGF AirVent ECA(Top of Riser)
Drains & Spkr Connections	Sight Glass
Drains & Spkr Connections	D-2 Accelerator Trim
Drains & Spkr Connections	Air Piping
Drains & Spkr Connections	Water Motor Pipe
Drains & Spkr Connections	System Testing
Drains & Spkr Connections	System Disinfection
Fire Hose Equipment	1 1/2" Hose Rack
Fire Hose Equipment	2 1/2" Hose Rack
Fire Hose Equipment	1 1/2" Hose Reel
Fire Hose Equipment	2 1/2" Hose Reel
Fire Hose Equipment	2-1/2" FHV Brass
Fire Hose Equipment	2-1/2" FHV Chrome
Fire Hose Equipment	2 1/2" FHV PRES REG
Fire Hose Equipment	Fire Ext.
Fire Hose Equipment	Fire Ext.
Fire Hose Equipment	Temp FDC
Fire Hose Equipment	Fire Dept Conn
Fire Hose Equipment	BFP Test Conn
Fire Hose Equipment	Roof Manifold
Fire Hose Equipment	Wall Hydrant
Fire Hose Equipment	Roof Hose House
Fire Hose Cabinets & Misc. Equip.	Hose Cabinet
Fire Hose Cabinets & Misc. Equip.	Hose Cabinet
Fire Hose Cabinets & Misc. Equip.	Hose Cabinet
Fire Hose Cabinets & Misc. Equip.	Hose Cabinet
Fire Hose Cabinets & Misc. Equip.	Valve Cabinet
Fire Hose Cabinets & Misc. Equip.	Valve Cabinet
Fire Hose Cabinets & Misc. Equip.	Valve Cabinet
Fire Hose Cabinets & Misc. Equip.	Ext Cabinet
Fire Hose Cabinets & Misc. Equip.	Ext Cabinet
Fire Hose Cabinets & Misc. Equip.	Ext Cabinet
Fire Hose Cabinets & Misc. Equip.	4" MetraFlex
Fire Hose Cabinets & Misc. Equip.	6" MetraFlex
Fire Hose Cabinets & Misc. Equip.	8" MetraFlex
Fire Hose Connections	1 1/2 Hose Conn
Fire Hose Connections	2 1/2 Hose Conn
Fire Hose Connections	1 1/2 Valve Conn
Fire Hose Connections	2 1/2 Valve Conn
Fire Hose Connections	FDC Pipe & Ftgs
Fire Hose Connections	FDC Pipe & Ftgs
Fire Hose Connections	Roof Manifold Conn
Fire Hose Connections	Wall Hyd Conn
Fire Hose Connections	Roof House Conn
Underground Pipe & Fittings	4" Underground
Underground Pipe & Fittings	6" CL52 DCL Fastite Pipe
Underground Pipe & Fittings	8" Underground
Underground Pipe & Fittings	10" Underground
Underground Pipe & Fittings	12" Underground
Underground Pipe & Fittings	6" MJ 90 Elbow
Underground Pipe & Fittings	6" Fast Grip Gasket
Underground Pipe & Fittings	6" MJ C153 Accy Pk W/Gld
Underground Valves & Equipment	4" NRS Gate Va
Underground Valves & Equipment	6" NRS Gate Va
Underground Valves & Equipment	8" NRS Gate Va
Underground Valves & Equipment	10" NRS Gate Va
Underground Valves & Equipment	12" NRS Gate Va
Underground Valves & Equipment	Hydrant
Underground Valves & Equipment	Hyd w/ Aux Gate
Underground Valves & Equipment	Post Indicator
Underground Valves & Equipment	Road Box
Underground Valves & Equipment	Hose Cab Comp
Underground Valves & Equipment	Hose Cart Comp
Underground Valves & Equipment	Hose House Comp
Underground Valves & Equipment	Tapping Va & Slv
Underground Valves & Equipment	Tamper Switch
Misc. Underground	Cut-Ins
Misc. Underground	Cut-Ins
Misc. Underground	Tap Main
Misc. Underground	Flushing
Misc. Underground	Testing
Misc. Underground	Chlorination
Misc. Underground	Rodding
Misc. Underground	Thrust Block
Misc. Underground	Hyd Pad
Misc. Underground	Guard Post
Misc. Underground	Hose House Pad
Fire Pumps & Equipment	Electric Pump w/ ATS
Fire Pumps & Equipment	Electric Pump w/o ATS
Fire Pumps & Equipment	Diesel Pump
Fire Pumps & Equipment	Diesel Pump
Fire Pumps & Equipment	Jockey Pump
Fire Pumps & Equipment	Test Header
Fire Pumps & Equipment	Flow Meter
Fire Pumps & Equipment	Relief Va.(CLAVAL 55L-60)
Fire Pumps & Equipment	Fill Pump
Fire Pumps & Equipment	Water Alt. Va
Fire Pump Valves	4" OS&Y
Fire Pump Valves	5" OS&Y
Fire Pump Valves	6" OS&Y
Fire Pump Valves	8" OS&Y
Fire Pump Valves	10" OS&Y
Fire Pump Valves	12" OS&Y
Fire Pump Valves	4" Swing Chk
Fire Pump Valves	5" Swing Chk
Fire Pump Valves	6" Swing Chk
Fire Pump Valves	8" Swing Chk
Fire Pump Valves	10" Swing Chk
Fire Pump Valves	12" Swing Chk
Fire Pump Valves	Y-Strainer
Fire Pump Valves	Tamper Switch
Misc Pump Equipment	Set Pumps
Misc Pump Equipment	Set Controllers
Misc Pump Equipment	Pump Piping
Misc Pump Equipment	By-Pass Piping
Misc Pump Equipment	Test Header Pipe
Misc Pump Equipment	Relief Va. Pipe
Misc Pump Equipment	Jockey Pump Pipe
Misc Pump Equipment	Controller Pipe
Misc Pump Equipment	Exhaust Piping
Misc Pump Equipment	Fuel System Pipe
Misc Pump Equipment	Tank Piping
Misc Pump Equipment	Pump Testing
Misc Pump Equipment	Fire Pump Fuel

 

[kweaver]

I think you'll find a good clear explanation here: Dependent