Hi. I am creating a worksheet and I would like to be able to hide certain
rows with a single click. I don't think the group/ungroup function will work
for me. Here is what I am trying to do:

Lets say I have the following rows:

Scenario A - Item #1
Scenario B - Item #1
Scenario C - Item #1
Scenario A - Item #2
Scenario B - Item #2
Scenario C - Item #2
Scenario A - Item #3
Scenario B - Item #3
Scenario C - Item #3

Is there a way to do this such that I can click a button and it will hide
all of the Scenario B&C items so that I just see Scenario A? I would like to
be able to choose the scenario and hide the other 2. Thanks in advance.
Chris