Filter with multiple criteria

[edesroch]

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

[dangelor]

Possibly...

Please Login or Register  to view this content.

[edesroch]

Thank you for the code.

Unfortunatly my problem still persists because the proposed code filters the data by line (Warehouse 1 + Product A + Blue ; Product B + Yellow regardless of the location; Product D regardless of the location and color) and not by column.

I am looking to have as a result Product A, B or C that are Blue or Yellow and located in Warehouse 1.

Regards

[sintek]

Please Login or Register  to view this content.

[edesroch]

You nailed it! Thank you so much.

[sintek]

.........................................
Thanks.gif