Advanced filter - data validation

[robgiuss]

When I select a field from the DATA1 (item1) and press the FILTERME button I get the filtered data.
If I want to use another filter, for example DATA3, in the list to select I find all the fields (100-200-300), while I would like to find only those that can affect the value of DATA1 (therefore the values 100 and 200 and not the value 300). I enclose example file. Can someone help me. Thank you.

[JLGWhiz]

Your criteria range A2:F3 is set up to allow only one value per column. If you want to filter on more than one value per column then change the filter range in the code to add a row to the criteria range. eg. CriteriaRange:=Range("A2:F4"), Then you can filter on more than one value per column. But if you are filtering for a value in Column 1 and two values in column 3 then the value for column 1 must be entered on both row 3 and 4, else it will return all matches for the second value listed on row 4.

[robgiuss]

Thanks for the reply but unfortunately it doesn't work.
If I select a value in column 1 when I select column 2 it shows me all the values ​​again while some do not concern the selection of column 1.
Example: I select "item1" and then in column 2 I should find to select only the colors "WHITE" and "RED" and not the other colors "blue" and "yellow".
Thank again for your help !!!

[kvsrinivasamurthy]

Say
Data1= Item1
Data2= White
then In Data3 You want 100, 200

Data1= Item1
Data2= red
then In Data3 You want 100

Also is selection is done in consecutive way.
Data1
Data2
Data3
Data4
etc...

[JLGWhiz]

Your criteria range is not set up to filter for more than one value per column. I am not sure how you are using the table titled "Values" or if it comes into play at all for what you are attempting to do, But the filter works as it should when I make direct entries into the cells on row 3 and then click the Filter button.