Searching multiple columns

I want to develop a macro that will allow me to search multiple columns and then copy the respective row onto another sheet

Search 1:
Column A = "y"
Column B = "" <~Blank

Copy to sheet 2

Search 2:
Column A = "y"
Column C = "y"

Copy to sheet 2

I have code the I used for 1 search term that works great from tigeravatar:

Please Login or Register  to view this content.