Check buttons ( or radio)

It sounds like you would have a lot of boxes using that method

Another option is to use a Toggle macro that places/removes a X from a cell in a column when it is selected or maybe even double clicked and then use Autofilter to filter on the X. (This is an expanded idea based o martindwilson suggestion)

The above suggestion allows for changing number of rows of data