Using multiple checkboxes to autofilter several columns

[rabert]

Hi!

My first post here... See attached .xlsx-file.

HELP NEEDED:
The sunglasses (column A) are available in different colours, hence the seven colour categories (column C:I). I want to be able to sort through the colours and sunglasses through the checkboxes by looking at the "x"-mark. When all the checkboxes are marked, all rows should be visible. But when I for instance check the orange, black and white checkboxes, only the Retro and Sporty sunglasses should be visible (autofiltered by the correspondent "x") I would also like to be able to select all the checkboxes at once as well as clear them all through the buttons next to the list.

This should be possible through VBA? If anyone could provide me with the VBA solution or a substituted solution working in some other way i would be most grateful!

//rabert