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
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies