Dependent drop down lists with multiple words - replicating the validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1641703%22%20slang%3D%22en-US%22%3EDependent%20drop%20down%20lists%20with%20multiple%20words%20-%20replicating%20the%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1641703%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CDIV%20class%3D%22MessageSubject%22%3E%3CDIV%20class%3D%22MessageSubjectIcons%20%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20trouble%20with%20dependent%20drop%20down%20lists.%20I%20managed%20to%20follow%20a%20tutorial%20here%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.xelplus.com%2Fexcel-dependent-drop-down-lists-multiple-words-spaces%2F%23%3A~%3Atext%3DGo%2520to%2520the%2520cell%2520where%2Coption%2520for%2520the%2520first%2520dropdown%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.xelplus.com%2Fexcel-dependent-drop-down-lists-multiple-words-spaces%2F%23%3A~%3Atext%3DGo%2520to%2520the...%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20managed%20to%20get%20the%20dependent%20data%20validation%20working.%20However%2C%20it%20will%20only%20work%20on%20the%20first%20row%20(where%20i%20originally%20inserted%20the%20data%20validation%20formula).%20When%20I%20attempt%20to%20copy%20the%20validation%20down%20the%20sheet%2C%20it%20only%20copies%20what%20is%20in%20the%20first%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20example%2C%20the%20dependents%20are%201.%20a%20list%20of%20standards%2C%20and%202.%20a%20list%20of%20standard%20categories.%26nbsp%3B%3C%2FP%3E%3CP%3ESo.%20Line%201%20(where%20i%20wrote%20the%20original%20data%20validation%20formula)%20cell%202C%20i%20select%20from%20a%20list%20of%20standards%2C%20and%20then%20in%202D%20I%20get%20a%20list%20of%20standard%20categories%2C%20based%20on%20what%20i%20selected%20in%202C.%20However%2C%20when%20I%20attempt%20to%20copy%20the%20data%20validation%20down%2C%20I%20am%20able%20to%20select%20from%20the%20list%20of%20standards%20in%203C%20just%20as%20above%2C%20but%20in%20cell%203D%20It%20just%20copies%20the%20standard%20categories%20from%202C%20(minus%20the%20one%20already%20showing%20in%20the%20row%20above.)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20really%20struggling%20to%20understand%20why!!%20Can%20anyone%20help%3F%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1641703%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1645859%22%20slang%3D%22en-US%22%3ERe%3A%20Dependent%20drop%20down%20lists%20with%20multiple%20words%20-%20replicating%20the%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F784657%22%20target%3D%22_blank%22%3E%40heatherguest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20that%20is%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdependent-drop-down-after-1st-line%2Fm-p%2F1643350%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdependent-drop-down-after-1st-line%2Fm-p%2F1643350%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
 

Hi, 

 

I am having trouble with dependent drop down lists. I managed to follow a tutorial here: 

 

https://www.xelplus.com/excel-dependent-drop-down-lists-multiple-words-spaces/#:~:text=Go%20to%20the....

 

and managed to get the dependent data validation working. However, it will only work on the first row (where i originally inserted the data validation formula). When I attempt to copy the validation down the sheet, it only copies what is in the first row.

 

So for example, the dependents are 1. a list of standards, and 2. a list of standard categories. 

So. Line 1 (where i wrote the original data validation formula) cell 2C i select from a list of standards, and then in 2D I get a list of standard categories, based on what i selected in 2C. However, when I attempt to copy the data validation down, I am able to select from the list of standards in 3C just as above, but in cell 3D It just copies the standard categories from 2C (minus the one already showing in the row above.) 

 

I am really struggling to understand why!! Can anyone help? 

1 Reply