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 4479 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


3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 7, 2013 at 05:55 AM
why not apply filter only ?
0
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
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 7, 2013 at 07:05 AM
why filter condition "End With" .net.us wont work ?
0
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.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 7, 2013 at 07:20 AM
use this for filter
*@*.*.*
0
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
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 7, 2013 at 05:41 PM
open excel
start macro recorder
apply filter
stop macro recorder

you have your macro
0