Excel - How do you duplicate information if it matches a criteria

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


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Philip Errington

Data>Autofilter for Y in column C.

Copy visible cells to another area or worksheet.


Gord