Hi Gunnett,

Have you tried Autofilter? Sounds like it should do what you want.

Select the range of columns >data >autofilter

Ed