TornadoThomo
New Member
- Joined
- Nov 24, 2017
- Messages
- 1
I would like to be able to hide certain groups of rows if, for example the name of the group was selected in a drop down list elsewhere in the Spread sheet.
For example, If I have a group of rows (rows 10 through to 15) and I have named the group "Derivs", How can I arrange for the group to be hidden if the name "Derivs" was selected in cell "c2" for example.
I had a solution where could achieve this by just selecting the row range (10:15), but the problem I have is with maintenance. If I need to add to the spreadsheet/cellrange at some point in the future (add a row in the middle of this range) thissolution would not take the change into account and would not include the lastrow in the new range required. Whereby I believe if I group the rows, this willaccommodate any changes I make to the group.
Thank you in advance for your help
For example, If I have a group of rows (rows 10 through to 15) and I have named the group "Derivs", How can I arrange for the group to be hidden if the name "Derivs" was selected in cell "c2" for example.
I had a solution where could achieve this by just selecting the row range (10:15), but the problem I have is with maintenance. If I need to add to the spreadsheet/cellrange at some point in the future (add a row in the middle of this range) thissolution would not take the change into account and would not include the lastrow in the new range required. Whereby I believe if I group the rows, this willaccommodate any changes I make to the group.
Thank you in advance for your help