Writing rule in ms excel using vb

Closed
trainhr1 Posts 4 Registration date Thursday February 7, 2013 Status Member Last seen February 7, 2013 - Feb 7, 2013 at 05:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 7, 2013 at 05:41 PM
Hello,

my question is...i'm having huge customer list mails in the format

******@***.es.us

******@***.es.in

******@***.net.us

******@***.us

******@***.net.us

******@***.es.in

******@***.net.en

.
.
.
etc......


from that table i want to filter only the mails which are in below format

******@***.net.us

please help me with macro


Related:

3 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 7, 2013 at 05:55 AM
why not apply filter only ?
trainhr1 Posts 4 Registration date Thursday February 7, 2013 Status Member Last seen February 7, 2013
Feb 7, 2013 at 06:07 AM
if we apply filter only specific extension like ******@***.net.us will obtain....bt this sheet is combination of diff extensions like

******@***.net.us
******@***.ed.us
******@***.net.sp

i want to retrieve all with this format
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 7, 2013 at 07:05 AM
why filter condition "End With" .net.us wont work ?
trainhr1 Posts 4 Registration date Thursday February 7, 2013 Status Member Last seen February 7, 2013
Feb 7, 2013 at 07:14 AM
if i apply that it retrieves only mails with .net.us extension.......but not other like

.net.in
.net.sp
.in.us
.
.
.
etc.....

i want the entire format
(.net.in
.net.sp
.in.us) to be retrieved .........i want macro to filter mails with double dot extension leaving single dot.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 7, 2013 at 07:20 AM
use this for filter
*@*.*.*
trainhr1 Posts 4 Registration date Thursday February 7, 2013 Status Member Last seen February 7, 2013
Feb 7, 2013 at 07:25 AM
can i use that stmt while writing macro program.........

plz provide me macro program for that.....because we had thousands of excel sheets
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 7, 2013 at 05:41 PM
open excel
start macro recorder
apply filter
stop macro recorder

you have your macro