Home

Show rows based on dropdown selections

%3CLINGO-SUB%20id%3D%22lingo-sub-656942%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20rows%20based%20on%20dropdown%20selections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656942%22%20slang%3D%22en-US%22%3EYou%20may%20refer%20to%20my%20response%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FData-validation-lists-flow-chart%2Fm-p%2F352133%23M25722%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FData-validation-lists-flow-chart%2Fm-p%2F352133%23M25722%3C%2FA%3E%3CBR%20%2F%3EAlso%2C%20you%20may%20attach%20your%20sample%20file%20by%20changing%20the%20names%20and%20limiting%20the%20amount%20of%20information%20without%20compromising%20confidentiality%20and%20sacrificing%20clarity.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658250%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20rows%20based%20on%20dropdown%20selections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658250%22%20slang%3D%22en-US%22%3ESo%20I%20did%20take%20a%20look%20at%20the%20thread%20you%20linked%20me%20to%2C%20but%20that's%20not%20what%20I'm%20trying%20to%20do.%20I%20want%20an%20entire%20row%20to%20be%20hidden%20until%20my%20dropdown%20selection%20indicates%20a%20specific%20answer.%20I'll%20include%20the%20closest%20thing%20I'm%20willing%20to%20risk%20to%20what%20I'm%20trying%20to%20do%20into%20my%20original%20post.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656881%22%20slang%3D%22en-US%22%3EShow%20rows%20based%20on%20dropdown%20selections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656881%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20last%20post%20apparently%20got%20marked%20as%20spam%2C%20so%20let's%20try%20this%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20enable%20my%20spreadsheet%20to%20show%20certain%20rows%20based%20on%20which%20option%20is%20selected%20in%20the%20dropdown.%26nbsp%3B%20So%20for%20example%2C%20if%20the%20question%20'How%20many%20vehicles%3F'%20is%20answered%20with%20a%20'2'%2C%20the%20only%20'Vehicle%201%20description'%20and%20'vehicle%202%20description'%20show.%26nbsp%3B%20I've%20included%20images%20of%20both%20my%20attempted%20codes%3B%20neither%20are%20working%20thus%20far.%26nbsp%3B%20I%20was%20hoping%20for%20some%20guidance%20about%20what%20I%20may%20be%20doing%20wrong%2C%20so%20I%20can%20get%20the%20actual%20spreadsheet%20I'm%20working%20on%20up%20and%20running.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20not%20include%20a%20screenshot%20of%20my%20actual%20spreadsheet%20to%20protect%20the%20data%20I'm%20working%20on%3B%20the%20screenshot%20below%20is%20a%20sample.%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%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116499i4C04F19AD911CC35%2Fimage-dimensions%2F400x80%3Fv%3D1.0%22%20width%3D%22400%22%20height%3D%2280%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%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%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116512i21325EF6F9CFFC83%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116534i6EE96BDDCE06A262%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20be%20continuing%20to%20work%20with%20the%20code%20in%20the%20meantime%2C%20but%20if%20someone%20could%20point%20me%20in%20the%20right%20direction......thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-656881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
flamesea
New Contributor

My last post apparently got marked as spam, so let's try this again.

 

I'm trying to enable my spreadsheet to show certain rows based on which option is selected in the dropdown.  So for example, if the question 'How many vehicles?' is answered with a '2', the only 'Vehicle 1 description' and 'vehicle 2 description' show.  I've included images of both my attempted codes; neither are working thus far.  I was hoping for some guidance about what I may be doing wrong, so I can get the actual spreadsheet I'm working on up and running. 

 

I did not include a screenshot of my actual spreadsheet to protect the data I'm working on; the screenshot below is a sample.

 

Capture.PNG

 

Capture.PNG

Capture.PNG

 

I'll be continuing to work with the code in the meantime, but if someone could point me in the right direction......thank you.

2 Replies
Highlighted
You may refer to my response in this link:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352133#M25722
Also, you may attach your sample file by changing the names and limiting the amount of information without compromising confidentiality and sacrificing clarity.
So I did take a look at the thread you linked me to, but that's not what I'm trying to do. I want an entire row to be hidden until my dropdown selection indicates a specific answer. I'll include the closest thing I'm willing to risk to what I'm trying to do into my original post.
Related Conversations