filter email addresses

[Angel]

I have a database of emails that I'm trying to extract all email addresses
with certain domain.com criteria. I have the criteria range at the top as
email
="=*yahoo.com"
a blank row
email
data range below

I have followed all the instructions to the letter and am still not getting
any filtering. My data doesn't do anything.

[VBA Noob]

I assume this is using advance filter


Try

*YAHOO.COM*

VBA Noob

[Angel]

yes, I figured out how to do it in auto, but how do I advance filter with
"contains"?

"VBA Noob" wrote:

>
> I assume this is using advance filter
>
>
> Try
>
> *YAHOO.COM*
>
> VBA Noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=573455
>
>

[Ron de Bruin]

Hi Angel

The criteria range is two cells, not one

Headername
*Yahoo*



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Angel" <[email protected]> wrote in message news:[email protected]...
> yes, I figured out how to do it in auto, but how do I advance filter with
> "contains"?
>
> "VBA Noob" wrote:
>
>>
>> I assume this is using advance filter
>>
>>
>> Try
>>
>> *YAHOO.COM*
>>
>> VBA Noob
>>
>>
>> --
>> VBA Noob
>> ------------------------------------------------------------------------
>> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
>> View this thread: http://www.excelforum.com/showthread...hreadid=573455
>>
>>