Hi All,
Been awhile since I've been on here, so hopefully the community is still as vibrant as when I asked questions 8 years ago!

I have a worksheet where there is a column (Column I) with keywords meant to abbreviate another part of that row. For example, in the cells are keywords such as "PPV", "FN", or "FNP." Those keywords are there for the purpose of grouping together like items for calculating a Sumproduct bottomline.

On the top of this worksheet, I'd like to have a checkbox. Whenever I check the Box that is labeled as "PPV", I would like to hide the rows that are labeled anything but "PPV." Same for "FN." When I check that box, hide everything but "FN."

I found a video where I can hide select rows using a Macro, but this worksheet is a couple hundred rows long and I don't want to have to input each individual row to isolate just the "PPV" rows. Also, I'll be adding to this file regularly.

Any thoughts on how to best deliver this output? I am thinking it might be a function related to |=IF ("FN") Then Hide Row| if "PPV" is checked, etc.

Thank You!
Brian (BTray90)