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

HELP from BRAZIL <<<<<<

Dear Philip, Good Afternoon.

Your explanation was very clear.

I did an example for you.
The formulas are very simple.

Take a look at it and tell me if it worked for you.
Fell free to ask anything about it.

Have a nice day.

Works perfectly

Thank you for taking the time and effort on this its very much appreciated.

Phil

DataAutofilter for Y in column C.

Copy visible cells to another area or worksheet.


Gord

On Sat, 28 Apr 2012 16:39:59 +0000, Philip Errington
wrote:


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


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