Auto populate data with a drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2771223%22%20slang%3D%22en-US%22%3EAuto%20populate%20data%20with%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2771223%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20employees%20separated%20by%20department.%26nbsp%3B%20I%20want%20to%20be%20able%20to%20select%20the%20department%20from%20a%20drop%20down%20list%20and%20populate%20a%20list%20of%20employees%20in%20a%20column.%26nbsp%3B%20So%20if%20I%20have%20a%20dropdown%20list%20of%20departments%20where%20it%20says%20computer%20services%20I%20want%20to%20be%20able%20to%20select%20that%20and%20then%20it%20fill%20in%20a%20list%20of%20names%20in%20column%20b%20under%20staff%20name%20that%20are%20in%20that%20department.%26nbsp%3B%20This%20would%20change%20per%20department%20selected.%26nbsp%3B%20The%20rest%20of%20the%20fields%20would%20be%20left%20to%20be%20filled%20in%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Acorn1812_0-1632242713949.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311838i4C7003EB6357FF7A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Acorn1812_0-1632242713949.png%22%20alt%3D%22Acorn1812_0-1632242713949.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2771223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2772036%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populate%20data%20with%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772036%22%20slang%3D%22en-US%22%3EThe%20best%20way%20to%20do%20this%20is%20to%20format%20the%20whole%20range%20as%20a%20table%20and%20use%20the%20autofilters%20built%20into%20the%20table%20(the%20little%20down%20triangles%20added%20to%20each%20header).%20I'm%20suggesting%20this%20method%20specifically%20because%20the%20last%20line%20you%20say%20%22The%20rest%20of%20the%20fields%20would%20be%20left%20to%20be%20filled%20in%20manually.%22%20and%20although%20you%20could%20use%20pivot%20tables%20with%20slicers%20and%20such%20or%20data%20validation%20drop%20down%20menus%2C%20those%20will%20only%20display%20the%20resulting%20'filter'.%20In%20order%20for%20you%20to%20ENTER%20DATA%20that%20will%20stay%20with%20the%20corresponding%20names%20you%20need%20the%20whole%20thing%20to%20be%20a%20table%20and%20then%20filter%20the%20relevant%20lines%20and%20then%20you%20can%20enter%20the%20data%20on%20those%20lines.%20I%20hope%20that%20makes%20sense.%20If%20you%20need%20more%20help%20please%20attach%20a%20sample%20sheet%20and%20I%2Fwe%20can%20tweak%20it%20if%20needed.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a list of employees separated by department.  I want to be able to select the department from a drop down list and populate a list of employees in a column.  So if I have a dropdown list of departments where it says computer services I want to be able to select that and then it fill in a list of names in column b under staff name that are in that department.  This would change per department selected.  The rest of the fields would be left to be filled in manually.

 

Acorn1812_0-1632242713949.png

 

1 Reply
The best way to do this is to format the whole range as a table and use the autofilters built into the table (the little down triangles added to each header). I'm suggesting this method specifically because the last line you say "The rest of the fields would be left to be filled in manually." and although you could use pivot tables with slicers and such or data validation drop down menus, those will only display the resulting 'filter'. In order for you to ENTER DATA that will stay with the corresponding names you need the whole thing to be a table and then filter the relevant lines and then you can enter the data on those lines. I hope that makes sense. If you need more help please attach a sample sheet and I/we can tweak it if needed.