Jun 26 2020 01:52 PM
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
Jun 26 2020 06:09 PM - edited Jun 26 2020 06:09 PM
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