Advanced filter macro (If,Then,Else)

[kokapelly]

Hi All,

I am working to change a simple macro i have that let user enter data into Sheet (Finder) I then use the below code to bring back data once found

Please Login or Register  to view this content.

I am trying now to make so it will allow the search even if one of the criteria is blank:

Please Login or Register  to view this content.

[kokapelly]

Doesn't work even when trying to use a single cell ref for the criteria

Please Login or Register  to view this content.

[kokapelly]

Attached my mess... this is my work (test) workbook

[kokapelly]

Any chance someone could take a look at my mess?

[kokapelly]

Someone...?

[kokapelly]

so many views but no answer...