I need some help on a scenario that I haven't run into before.

I have about 10000 rows with data that is filtered by a store number.

I need to generate reports based on groups of stores. These groups range from 8-20 locations.

Instead of going in and clicking store 1,4,6,7,9 I wrote a macro to auto select these, and have bound that to a form control check box for that "group"

I have about 30 of these groups and have run out of shortcut keys in excel.

Is there something easy I am missing? Is there a way to set up a drop down menu that would select these groups for me?

Ex.
menu selection "Group A"
Locations in column A: 1,4,6,7,8

menu selection "Group B"
Location in column A: 2,3,5,8,10,15

This continues on for 30+ groups.

Any help is appreciated!