I need to

look at all the rows in the current worksheet
find all the ones with a 'Y' in column"A"

for all the ones with 'Y' in Col "A", copy cols 'A' to 'S' to the worksheet
(Next)

I would really appreciate the help :)

thanks
Jinx123