Hi all! I’m looking for help creating a code to show/hide specific rows when certain options are selected. I looked at some previous responses but couldn’t figure out how to adapt it for my needs.

In my spreadsheet, there’s a multiple choice drop down picklist in cell B12 with picklist options titled Claim 1-8. I’m looking to show/hide rows 16-23, which correspond to the claim 1-8 numbering in the B12 drop down. For example- if claims 1 and 6 are selected in cell B12, I want to show Row 16 and 21, and hide all others.

Would love any help or advice!

​Hi all! I’m looking for help creating a code to show/hide specific rows when certain options are selected. I looked at some previous responses but couldn’t figure out how to adapt it for my needs. In my spreadsheet, there’s a multiple choice drop down picklist in cell B12 with picklist options titled Claim 1-8. I’m looking to show/hide rows 16-23, which correspond to the claim 1-8 numbering in the B12 drop down. For example- if claims 1 and 6 are selected in cell B12, I want to show Row 16 and 21, and hide all others. Would love any help or advice!  Read More

​