need the data in drop down list and dependend drop down list

[gabi1981986]

hence iam new to excel i need a help i have data like belo mentioned

MG_DESC SG_DESC SSG_DESC
024 ABRASIVE 11 ITEM:CLOTH,ROLL 111 MATERIAL:EMERY
024 ABRASIVE 15 ITEM:DISC 981 MATERIAL:ZIRCONIA
024 ABRASIVE 19 ITEM:EMERY PAPER 013 MATERIAL:ALUMINIUM OXIDE/SILICON CARBIDE
893 ABSORPTION SYSTEM PARTS/ACCESSORIES 81 MAKE:THERMOSET POLY 815 DW:TPP/SCR/084/PS-2008/7
591 ACTUATOR ELECTRIC 17 TYPE:DIRECT COUPLED 010 TORQUE:BELOW 100 NM
591 ACTUATOR ELECTRIC 60 TYPE:MOTOR OPERATED VALVE 020 TORQUE:101-200 NM
591 ACTUATOR ELECTRIC 60 TYPE:MOTOR OPERATED VALVE 050 TORQUE:401-500 NM
861 ACTUATOR PARTS/ACCESSORIES 02 MAKE:AUMA 710 MODEL:SA50A45
861 ACTUATOR PARTS/ACCESSORIES 18 MAKE:EL-O-MATIC 150 MODEL:ED40
861 ACTUATOR PARTS/ACCESSORIES 18 MAKE:EL-O-MATIC 160 MODEL:ED350
861 ACTUATOR PARTS/ACCESSORIES 18 MAKE:EL-O-MATIC 170 MODEL:ES40
861 ACTUATOR PARTS/ACCESSORIES 18 MAKE:EL-O-MATIC 172 MODEL:ES100



i want to creat all data in drop down list with the help of 1st column

for example

if i select 024 abrasive in 1st drop down list in second drop down list the value equal to 024 abrasive in 2nd column should be viewed the same in 3rd drop down also.

if any one can please explain how can i prepare this.thanks in advance.

[dominicb]

Good morning gabi1981986

These are usually referred to as Dynamic (or Dependent) Dropdowns. Debra Dalgleish provides a full tutorial and walkthrough, including a video, here.

HTH

DominicB