Filter with multiple criteria

Hi all,

I am struggling since a few days with writting a macro.

- I want to create a macro which allows me to filter the data in the table in green according to the selected criteria of the section in orange and to copy the result in the table in yellow.

- The Location is determined by an option button that only allows to select one location.

- The Product are determined by check boxes and it is possible to select from none up to 4 products.

- The Color are determined by check boxes and it is possible to select from none up to 5 colors.

- I have already created the formulas so that the selected criteria of the option button and the check boxes appear in the table in orange.

Regards