Using Dropdown, Selectively Hide Rows assigned a specific Priority

[OurSegueBeard]

I have a big checklist. Many sheets, many test cases. Each test case is assigned a row, and along that row are a series of Pass / Fail dropdowns falling under different platforms (PC, Mobile, etc).

Every test case / row has a priority of 1, 2, or 3. Testers go through the checklist with the instruction to do only Priority 1 checks, or Priority 1 + 2, etc.

What I'm trying to do should be simple, but I can't figure it out.

Using a simple drowdown at the top of each sheet, the Tester needs to be able to select the Priority Pass(es) they're performing and expect all unrelated priorities / rows to be hidden.

Grouping only works for cells that are only in range of each other, and the testcases are not sorted / listed by priority in their sheets - instead the test cases are sorted / listed per the area of testing. So, I've moved away from Grouping.

Autofiltering seems too complicated for my testers to go in and change themselves each time, and the checklist is so often edited that I don't want to have to go back in constantly adding and editing ranges for every sheet.

Is there any simple, elegant solution I'm not seeing here?

Much appreciated,
OSB

[newdoverman]

Welcome to the forum.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.