I need a help to automatic change my dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-1601015%22%20slang%3D%22en-US%22%3EI%20need%20a%20help%20to%20automatic%20change%20my%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601015%22%20slang%3D%22en-US%22%3E%3CP%20data-unlink%3D%22true%22%3EHello%2C%20thank%20you%20in%20advance%20to%20see%20my%20problem.%3CBR%20%2F%3EI%20am%20a%20new%20user%20for%20excel%20and%20starting%20from%20basic%20to%20advanced.%20I%20have%20created%20a%20dropdown%20list%20on%20the%20excel%20sheet%20and%20all%20are%20done%20but%20when%20I%20change%20the%20main%20dropdown%20list%20than%20other%20it%20dependent%20dropdown%20list%20are%20not%20changing%20automatically%20why%3F%3F%3F%20for%20more%20clear%20of%20my%20question%20you%20can%20watch%20my%20private%20video%20which%20I%20have%20shared%20here...%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FNqgKBa7ZFy4%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMy%20Problem%20is%20this%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601015%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-1601125%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20a%20help%20to%20automatic%20change%20my%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601125%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765554%22%20target%3D%22_blank%22%3E%40kinggaramja%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20attached%20the%20sample%20which%20you%20are%20having%20the%20problem%20to%20debug%20and%20see%20the%20issue%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, thank you in advance to see my problem.
I am a new user for excel and starting from basic to advanced. I have created a dropdown list on the excel sheet and all are done but when I change the main dropdown list than other it dependent dropdown list are not changing automatically why??? for more clear of my question you can watch my private video which I have shared here...
My Problem is this 

1 Reply

Hi @kinggaramja 

 

Please attached the sample which you are having the problem to debug and see the issue 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more