filter email addresses
 

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.

filter email addresses
 

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

filter email addresses
 

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

filter email addresses
 

Hi Angel

The criteria range is two cells, not one

Headername
*Yahoo*



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



"Angel" wrote in message ...
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