Filter Option and Macros

Hello

I have MS excel 2007

the file I work with is very big around 200K lines ( its a csv file)

I have a column in the file that lists email addresses

some people did not put their email address correctly.

so what I do is I do a column filter for example for anything that ends with @yahoo , and then I change the results to @yahoo.com

or for example some people put @yahoo,com , so I filter that and change the filtered results to @yahoo.com

is there way to create a macro to do different types of filters and edit the results , instead of doing each one manually?

Just use the built-in search and replace.

Select the column, press Ctrl+F keys.

Find what: yahoo*

Replace With: yahoo.com

Replace All

hello, thanks for the fast reply.

How can make a macro just edit the results of a filter?

I have the following macro

Sub filteryahoo()
'
' filteryahoo Macro
' @yahoo
'

'
Selection.AutoFilter
ActiveSheet.Range("$A$1:$O$195631").AutoFilter Field:=3, Criteria1:= _
"=*@yahoo", Operator:=xlAnd
End Sub


It will basically filter column #3 with any cells that end with @yahoo
I want to be able to have the macro change only the results of the filter from @yahoo to @yahoo.com

I know there might better ways to change @yahoo to @yahoo.com, but I am looking to see how the macro can edit only the search results of a filter.

any ideas?

Record a macro using the search and replace as I described it and you will have the basic macro code.

However, you should always opt for using the built-in functionality of Excel before looking for a VBA solution because native functions/features are much faster and more efficient than ANY VBA code.