Writing rule in ms excel using vb

Closed
Report
Posts
4
Registration date
Thursday February 7, 2013
Status
Member
Last seen
February 7, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
why not apply filter only ?
0
Posts
4
Registration date
Thursday February 7, 2013
Status
Member
Last seen
February 7, 2013

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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
why filter condition "End With" .net.us wont work ?
0
Posts
4
Registration date
Thursday February 7, 2013
Status
Member
Last seen
February 7, 2013

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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use this for filter
*@*.*.*
0
Posts
4
Registration date
Thursday February 7, 2013
Status
Member
Last seen
February 7, 2013

can i use that stmt while writing macro program.........

plz provide me macro program for that.....because we had thousands of excel sheets
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
open excel
start macro recorder
apply filter
stop macro recorder

you have your macro
0