VBA code brands by conditions

[Knigtandday]

Hello Experts

I need a vba code that does the following:

Transfer to Sheet2 just the brands that have Green color , SIze L and available and should NOT have (blue color with XXL size and available).
For example

Brand1 has both (Green L YES) & (Blue XXL YES) so it shouldn´t be transfered to Sheet2 . Brand71 has (Green L Yes) &(Blue XXL but NO) so it can be transfered to Sheet2. Brand31 has (Green L Yes) but no (Blue XXL YES) so it can be transfered as well.

[Richard Buttrey]

Have you checked out the standard Advanced Data Filtering functionality which will do exactly what you want? No need for VBA unless you want to encode the data filtering.

[Knigtandday]

Have you checked out the standard Advanced Data Filtering functionality which will do exactly what you want? No need for VBA unless you want to encode the data filtering.

Yes I want to encode it

[Richard Buttrey]

If you perform the manual advanced data filter using your criteria and output ranges to produce an example of the results that you expect to see and upload the workbook again then I'll add the macro for you.

Regards