Forum Discussion
Hide Rows automatically depending on value of a cell
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 Cel...
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)
Hope that helps
Wyn
MVP
Australia UTC+ 8
If this answer was the best response please click the button
I also happily accept likes