Autofilter Macro according to TRUE / FALSE criteria

[Rossce]

Hi Rosco

I don't know how you managed to get the code I provided not to work and to make two if statements where one is adequate. Here is the code unaltered on your file.

Take care

Smallman

Hi Smallman,

I have downloaded your attachment, but still cannot get this to work. If I put TRUE in sheet12, cell C6, it should filter out column 1, the "Y". Then with that filter still on, will search sheet12, cell C7, see it says FALSE, then go back and filter out the blanks in column 11.

For example, if you type in "Y" in column 11 - rows 2 - 9, and type TRUE in Sheet12, cell C6, when you run the macro, it should first filter column 1 "Y" then go filter column 11, Blanks...you should be left with1 visible row.

Hope that makes sense

Rossce

[Smallman]

Hi Rosco

I thought your problem was an either or. If it was true in C6 then apply one filter otherwise apply another. You are talking about adding an AND condition and this will include both conditions. The following will cater for both conditions. Paste over the top of prior workbook code.

Take care

Smallman

Sub FilterCriteriasm() 
    Sheet2.AutoFilterMode = False 'Clear filter
     
    If Sheet12.Range("C6").Value = "TRUE" And Sheet12.Range("C7").Value = "FALSE" Then 
        Sheet2.Range("A1:AI1").AutoFilter 1, "Y" 
        Sheet2.Range("A1:AI1").AutoFilter 11, "=" 
    End If 
End Sub 

[Rossce]

Thanks Smallman,

Yep, that has worked treat - thank you for your time and help :-)

Rossce