Boolean Style Selection in Magic Sheet

Hi,

I'm working on a show file that has 23 different lighting areas across the stage, as well as 17 different angles/fixtures per area.

I have organized a magic sheet into two sections, the top which shows the acting areas, and bottom which shows the angles.

What I would like to do is have a mode selection where I can get to a single fixture out of the nearly 400 lights with two clicks.

In Eos, by default, if I select acting area 16 and Warm Toplight I would get all lights in both groups selected. What I want to be able to toggle is a mode where if I select acting area 16 It selects all lights in area 16, then when I select the Warm Toplight It changes the selection to lights that belong in both the warm toplight group as well as in the area 16 group.

I'm not too great at using macros or query, so I was just wondering if anyone knows a good way to do this on magic sheets. (possibly helping me learn how to write this macro if it can be done)

I've included a picture to help get an idea of what I'm looking at.

Thanks for any help offered

!

Related