Execl Macro

plamuren · May 13th, 2002, 01:23 AM

How can I use an excel macro to filter a table in Microsoft excel.
Here is an example of my table
Code 20318: AYODELE,M-4519P
Date Time Call Place Band Rate Distant Duration Cost Code
dd/mm/yyyy hh:mm Type Number hh:mm:ss $ Number
26/03/2002 09:14 Otg Benin F Standard 052252680 0:08:48 1.67 20318
19/03/2002 08:27 Otg United Kingdom 2 Standard 009447833621061 0:15:34 14.08 20318
18/03/2002 14:55 Otg United Kingdom 2 Standard 009447903681797 0:09:44 8.80 20318
18/03/2002 07:46 Otg United Kingdom 2 Standard 009447833621061 0:18:35 16.72 20318

Type Number Cost
$
Local etc. 0 0.00
STD 1 1.67
IDD 3 39.60
All Outgoing 4 41.27
All Incoming 0 0.00

I will like to remove items in Green.

crimlet · May 13th, 2002, 01:29 AM

We cant see the items in green, but to use the filter command in a macro include the code

Selection.AutoFilter field:=2, Criteria1:=MyValue, Operator:=xlAnd

the code above sets a sets the filter to use criteria 2 and look for a string helf in the Dim MyValue

If you could further enlighten us to what you want to do I could expand this further

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 01:23 AM	#1
plamuren New Member Join Date: May 2002 Posts: 1	How can I use an excel macro to filter a table in Microsoft excel. Here is an example of my table Code 20318: AYODELE,M-4519P Date Time Call Place Band Rate Distant Duration Cost Code dd/mm/yyyy hh:mm Type Number hh:mm:ss $ Number 26/03/2002 09:14 Otg Benin F Standard 052252680 0:08:48 1.67 20318 19/03/2002 08:27 Otg United Kingdom 2 Standard 009447833621061 0:15:34 14.08 20318 18/03/2002 14:55 Otg United Kingdom 2 Standard 009447903681797 0:09:44 8.80 20318 18/03/2002 07:46 Otg United Kingdom 2 Standard 009447833621061 0:18:35 16.72 20318 Type Number Cost $ Local etc. 0 0.00 STD 1 1.67 IDD 3 39.60 All Outgoing 4 41.27 All Incoming 0 0.00 I will like to remove items in Green.

May 13th, 2002, 01:29 AM	#2
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	We cant see the items in green, but to use the filter command in a macro include the code Selection.AutoFilter field:=2, Criteria1:=MyValue, Operator:=xlAnd the code above sets a sets the filter to use criteria 2 and look for a string helf in the Dim MyValue If you could further enlighten us to what you want to do I could expand this further