Please could any one help solve this problem as i cant figure it out.

I have a list of names in C1:C200 and in B1:B200 i have put "Y" if the people match a criteria i wanted.

Is there a way i can reproduce the list of names from C1:C200 to a different area with just the names that have "Y" next to them. i.e a shorter list?

Any help would be much appreciated.

I do hope this makes sense as its my first thread.

Regards


Phil