VBA Autofilter

I have a spreadsheet in which i want to display my information by two conditions.

In column 1 i only want it to filter to "Y"; HOWEVER if column 2 contains ANY text, i want the filter to be ignored and it to display the entire row.

Here's some images of an example sheet below:

1.png
2.png

Thanks,
Liam

Originally Posted by liamfrancis2013

In column 1 i only want it to filter to "Y"; HOWEVER if column 2 contains ANY text, i want the filter to be ignored and it to display the entire row.

Can you explain better that single part, what I understood was:
Filter column A with equal "Y" and then ? only show the line that has text on coumn B ?

Basically when i filter Column A to "Y" it will only show the cells that contain "Y", as you'd expect. However i also want any cell that has a value in it in column B to not be effected by the filter in column A.

With the aim of making my sheet look something like this:
1.png

The only thing I got is this:

Sub Button1_Click()
    For i = 2 To Cells(Rows.Count, "A").End(xlUp).Row
        If Cells(i, 1) <> "Y" And Cells(i, 2) = "" Then Rows(i & ":" & i).EntireRow.Hidden = True
    Next i
End Sub

It works, but you will have to work with it for different situations. Cells(Rows.Count, "A").End(xlUp).Row is to get the last cell on column A with something written (in this case, 11)...

Thanks, this looks like it might be the solution i'm after, i'm going to attempt applying it to the real version of my sheet now

Just some things to note when applying this on a different project:
-i starts with 2 so if you don't change it, you can't have the table lower to for example, starting at A5;
-the loop counts the last cell on column A if you don't change, you can't have the table in, for example, C1;
-that makes it so you can't have anything on column A after the table or the loop will do untill that cell with something that doesn't belong to the table;
-don't forget to change the <> "Y" and the = "";
-don't forget to change the 1 and the 2 inside the Cells() on the If statment;
-This hides the row, the same as the filter I think but it doesn't apply any filter so to make it appear, you do EntireRow.Hidden = False or clean your filters if you have any...