I have one worksheet with simple data and I want to isolate the rows where there is a "Y" in one of the columns and transport that data to another worksheet and for the life of me I cant get it right and Ive done some research and even asked a friend....I know this is probably simple, but I just cant wrap my head around it....

here is what it looks like :


02/21/12 09/07/12 Abdulkadir Seattle, WA 98126 Y
11/28/11 09/05/12 Alvarez Seattle, WA 98122