VBA Autofilter

[liamfrancis2013]

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

[rdrmdr]

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 ?

[liamfrancis2013]

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

[rdrmdr]

Well, it's weird I'm not finding anything but I'm not sure if it's possible using the filters because I can't find a way to do it manually (without VBA) so maybe using some loops.
I'm gonna see if I get anything. You need something like:
.Range("A1:B1").AutoFilter Field:=1, Criteria1:=("Y"), xlOr, Field:=2, Criteria1:=("*")
the problem is that the xlOr only seems to work with different criterias, not different columns/fields...

[rdrmdr]

The only thing I got is this:

Please Login or Register  to view this content.

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)...

[liamfrancis2013]

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

[rdrmdr]

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...