Selecting certain Rows and Copying cells in those rows to new work

[Jinx123]

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

 

[steve]

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