filter email addresses

[Guest]

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 Noo

 

[Guest]

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

 

[Ron de Bruin]

Hi Angel

The criteria range is two cells, not one

Headername
*Yahoo*