Home

linking drop list

%3CLINGO-SUB%20id%3D%22lingo-sub-740940%22%20slang%3D%22en-US%22%3Elinking%20drop%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CIMG%20alt%3D%22load%22%20src%3D%22http%3A%2F%2Fcdn.reverso.net%2Fspeller%2Fv1382%2FIMG%2Fdefault.gif%22%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3CDIV%20class%3D%22text_box%22%3E%3CSPAN%20class%3D%22sac%22%3EI'm%3C%2FSPAN%3E%20trying%20to%20%3CSPAN%20class%3D%22sac%22%3Emodify%3C%2FSPAN%3E%20an%20excel%20sheet%20that%20already%20has%20drop%20list%20%3CSPAN%20class%3D%22sac%22%3Efor%3C%2FSPAN%3E%20each%20column.%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20would%20like%20that%20the%20drop%20list%20changes%20%3CSPAN%20class%3D%22sac%22%3Eautomatically%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22sac%22%3Eaccording%3C%2FSPAN%3E%20to%20what%20was%20%3CSPAN%20class%3D%22sac%22%3Echosen%3C%2FSPAN%3E%20on%20the%20prior%20one.%20Example.%20on%20my%20first%20%3CSPAN%20class%3D%22sac%22%3Ecolumn%2C%20I%3C%2FSPAN%3E%20have%20a%20list%20of%20SITES%2C%20for%20the%20second%20column%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20have%20a%20list%20of%20MANAGERS%20and%20for%20the%20third%20column%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20have%20a%20list%20of%20%3CSPAN%20class%3D%22sac%22%3Ethe%20AGENTS%3C%2FSPAN%3E.%20now%20when%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20choose%20a%20SITE%2C%20on%20the%20MANAGER%20list%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20get%20them%20all%20and%20%3CSPAN%20class%3D%22sac%22%3Ethe%20same%20thing%3C%2FSPAN%3E%20for%20the%20AGENT%20column%20how%20could%20%3CSPAN%20class%3D%22sac%22%3EI%3C%2FSPAN%3E%20get%20only%20the%20MANAGER%20of%20the%20SITE%20t%3CSPAN%20class%3D%22sac%22%3Ehat%20was%26nbsp%3Bchosen%3C%2FSPAN%3E%20and%20same%20thing%20for%20the%20AGENT%20column%3C%2FDIV%3E%3CDIV%20class%3D%22text_box%22%3Eonly%20the%20agents%20of%20the%20manager%20%3CSPAN%20class%3D%22sac%22%3Echoosen%3C%2FSPAN%3E%20on%20the%20prior%20column%3C%2FDIV%3E%3CDIV%20class%3D%22text_box%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22text_box%22%3Eplease%20HELP!!!%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743574%22%20slang%3D%22en-US%22%3ERe%3A%20linking%20drop%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372063%22%20target%3D%22_blank%22%3E%40excel_team_bell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20is%20one%20of%20tutorials%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2FxlDataVal02.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.contextures.com%2FxlDataVal02.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743622%22%20slang%3D%22en-US%22%3ERE%3A%20linking%20drop%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743622%22%20slang%3D%22en-US%22%3Ethank%20you%20su%20much%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743633%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20linking%20drop%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743633%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372063%22%20target%3D%22_blank%22%3E%40excel_team_bell%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743650%22%20slang%3D%22en-US%22%3ERe%3A%20linking%20drop%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743650%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372063%22%20target%3D%22_blank%22%3E%40excel_team_bell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EThere%20are%20different%20methods%20for%20creating%20Dependent%20Drop%20Lists%2C%20where%20the%20contents%20of%20one%20drop%20list%20change%20based%20upon%20your%20selection%20in%20the%20other%20drop%20list%3C%2FP%3E%3CP%3EHere%20is%20my%20tutorial%20for%20creating%20them%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0MuQfUJbycQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0MuQfUJbycQ%3C%2FA%3E%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
excel_team_bell
New Contributor

load

I'm trying to modify an excel sheet that already has drop list for each column. I would like that the drop list changes automatically according to what was chosen on the prior one. Example. on my first column, I have a list of SITES, for the second column I have a list of MANAGERS and for the third column I have a list of the AGENTS. now when I choose a SITE, on the MANAGER list I get them all and the same thing for the AGENT column how could I get only the MANAGER of the SITE that was chosen and same thing for the AGENT column
only the agents of the manager choosen on the prior column
 
please HELP!!!
4 Replies
thank you su much

@excel_team_bell , you are welcome

@excel_team_bell 

Hi

There are different methods for creating Dependent Drop Lists, where the contents of one drop list change based upon your selection in the other drop list

Here is my tutorial for creating them

https://www.youtube.com/watch?v=0MuQfUJbycQ

Hope that helps

Nabil Mourad

Creating dependent drop lists. Using drop lists in Excel creates a dynamic professional worksheet. In a previous tutorial I explained how to create a drop list "Data Validation". In this tutorial we'll go one step farther by creating 2 drop lists where the contents of the second drop list change ...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies