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

Hi,
If you use a filter on column A, then it is just a question of copy and
paste the information to the other sheet.

Regards
Steve

"Jinx123" wrote in message
...
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