Hide Rows automatically depending on value of a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1493228%22%20slang%3D%22en-US%22%3EHide%20Rows%20automatically%20depending%20on%20value%20of%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493228%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I'm%20trying%20to%20find%20the%20best%20way%20to%20have%20rows%20hide%20automatically%20depending%20on%20the%20value%20of%20a%20specific%20cell.%3C%2FP%3E%3CP%3EMy%20Cell%20%22A22%22%20Is%20a%20Drop%20down%20list%20and%20I%20want%20the%20rows%20A23-A29%20to%20be%20hidden%20if%20my%20A22%20Cell%20is%20blank.%3C%2FP%3E%3CP%3EAnd%20when%20I%20select%20something%20from%20my%20Cell%20A22%20that%20the%20Rows%20A23-A29%20appear.%3C%2FP%3E%3CP%3EI%20have%20multiple%20cells%20that%20need%20to%20have%20the%20same%20Effect%3A%3C%2FP%3E%3CP%3EA31%26nbsp%3B%20%26nbsp%3Brelates%20to%20rows%20A32-A38%3C%2FP%3E%3CP%3EA40%20relates%20to%20rows%20A41-A47%3C%2FP%3E%3CP%3EPlease%20Help%20me%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1493228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493489%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20Rows%20automatically%20depending%20on%20value%20of%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493489%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20it%20needs%20to%20be%20completely%20automatic%20then%20you%20will%20need%20to%20write%20some%20VBA%20code%20-%20are%20you%20familiar%20with%20VBA%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20can%20live%20with%20a%201%20click%20solution%20you%20could%20potentially%20have%20a%20Table%20running%20down%20and%20a%20slicer%20to%20filter%20(see%20attached%20file)%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20832px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201656i0CEC15EA84CB6037%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EWyn%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EMVP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAustralia%20UTC%2B%208%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EIf%20this%20answer%20was%20the%20best%20response%20please%20click%20the%20button%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EI%20also%20happily%20accept%20likes%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi I'm trying to find the best way to have rows hide automatically depending on the value of a specific cell.

My Cell "A22" Is a Drop down list and I want the rows A23-A29 to be hidden if my A22 Cell is blank.

And when I select something from my Cell A22 that the Rows A23-A29 appear.

I have multiple cells that need to have the same Effect:

A31   relates to rows A32-A38

A40 relates to rows A41-A47

Please Help me 

Thanks 

1 Reply
Highlighted

If it needs to be completely automatic then you will need to write some VBA code - are you familiar with VBA?

 

If you can live with a 1 click solution you could potentially have a Table running down and a slicer to filter (see attached file) image.png

 

Hope that helps

 

Wyn

MVP

Australia UTC+ 8

 

If this answer was the best response please click the button

I also happily accept likes