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