VBA coding to autofilter the data ( with some criteria), when the data starts from row 3

V

Vishnu Kariappa

New Member
Joined
Mar 24, 2014
Messages
3
Hi All,

Could you all please assist me with some macro codings?

I have the data in between (A4:I256) range,there is "Tracker Status" in column "I". I want to write coding to filter only the items which consist "Action required".

[TABLE="width: 1507"]
<TBODY>[TR]
[TD]RegionCode</SPAN>[/TD]
[TD](All)</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OwnerCode</SPAN>[/TD]
[TD]PFA-TM</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EnteredDate[/TD]
[TD]AgencyCode[/TD]
[TD]LookupCode[/TD]
[TD]Description[/TD]
[TD]Status[/TD]
[TD]Description Status</SPAN>[/TD]
[TD]Lookup Code</SPAN>[/TD]
[TD]Entered Date</SPAN>[/TD]
[TD]NE-PFA Tracker Status</SPAN>[/TD]
[/TR]
[TR]
[TD]6/11/2014 2:59:19 PM[/TD]
[TD]MW[/TD]
[TD]BLACCON-10</SPAN>[/TD]
[TD]Complete - Effective: 6/4/14 Loan # (Quote #) 253039 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]BLACCON-10</SPAN>[/TD]
[TD="align: right"]11-Jun-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]6/20/2014 8:53:03 AM[/TD]
[TD]MW2[/TD]
[TD]SALEEDU-01</SPAN>[/TD]
[TD]Complete MW Effective:2014/2015 Quote # 2694248 Premium Financed Policy First Insurance $308,177.73[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]SALEEDU-01</SPAN>[/TD]
[TD="align: right"]20-Jun-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]6/23/2014 3:46:17 PM[/TD]
[TD]SC[/TD]
[TD]FUTUENE-01</SPAN>[/TD]
[TD]Completed - SC- - FINANCING: - Effective: LOan # 2698691 6/21/2014 - Premium Financed[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]FUTUENE-01</SPAN>[/TD]
[TD="align: right"]23-Jun-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]6/25/2014 12:05:25 PM[/TD]
[TD]MW2[/TD]
[TD]QUEECIT-07</SPAN>[/TD]
[TD]Complete PROP - Effective: Loan # (Quote #) 000002696740 6/16/2014 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]QUEECIT-07</SPAN>[/TD]
[TD="align: right"]25-Jun-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]6/27/2014 1:23:28 PM[/TD]
[TD]MW2[/TD]
[TD]BURK&SC-01</SPAN>[/TD]
[TD]MW Complete - - 6-26-14/15: - Loan # (Quote #) 1040903.1 Premium Financed Policy by Bank Direct[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]BURK&SC-01</SPAN>[/TD]
[TD="align: right"]27-Jun-14</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[/TR]
[TR]
[TD]7/1/2014 1:57:38 PM[/TD]
[TD]MW[/TD]
[TD]HUMACOR-01</SPAN>[/TD]
[TD]MW Complete EXDO - Effective: 6/16/2014 Loan # (Quote #) 000002697674. - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]HUMACOR-01</SPAN>[/TD]
[TD="align: right"]1-Jul-14</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[/TR]
[TR]
[TD]7/1/2014 10:17:45 AM[/TD]
[TD]MW[/TD]
[TD]RESTMAN-02</SPAN>[/TD]
[TD]MW Complete - Effective: 7/1/2014 Loan # (Quote #) 000002703506- Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]RESTMAN-02</SPAN>[/TD]
[TD="align: right"]1-Jul-14</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[/TR]
[TR]
[TD]7/10/2014 3:43:35 PM[/TD]
[TD]NE[/TD]
[TD]BIONITR-02</SPAN>[/TD]
[TD]Complete -NE- Effective: Loan# (Quote#) 1028350.1 - Premium Financed Policy 7/28[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]BIONITR-02</SPAN>[/TD]
[TD="align: right"]10-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/11/2014 8:02:40 AM[/TD]
[TD]SC[/TD]
[TD]BUILMEC-01</SPAN>[/TD]
[TD]Complete SC- IPFS $384831.69 - Effective: Loan # 2797558 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]BUILMEC-01</SPAN>[/TD]
[TD="align: right"]11-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/11/2014 9:11:30 AM[/TD]
[TD]MW[/TD]
[TD]SUNRSPE-01</SPAN>[/TD]
[TD]Complete - Effective: 7-1-14 - Loan # (Quote #) 1045689.1 Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]SUNRSPE-01</SPAN>[/TD]
[TD="align: right"]11-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/14/2014 1:50:34 PM[/TD]
[TD]NE[/TD]
[TD]LOURIND-01</SPAN>[/TD]
[TD]Complete -NE- Effective: Loan# (Quote #) 2799202 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]LOURIND-01</SPAN>[/TD]
[TD="align: right"]14-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/14/2014 10:18:10 AM[/TD]
[TD]SC[/TD]
[TD]MESQSER-01</SPAN>[/TD]
[TD]Complete-IP - Effective: Loan # (Quote) 1033785.2 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]MESQSER-01</SPAN>[/TD]
[TD="align: right"]14-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/15/2014 1:51:31 PM[/TD]
[TD]MW[/TD]
[TD]CASSAND-01</SPAN>[/TD]
[TD]Complete MW -PKG 14 - Effective: 6/29/14:Loan # (Quote #) 000002706137. - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]CASSAND-01</SPAN>[/TD]
[TD="align: right"]15-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/16/2014 3:28:29 PM[/TD]
[TD]NE[/TD]
[TD]AJBUILD-01</SPAN>[/TD]
[TD]Completed - NE - IN - Effective: Loan# (Quote#) 1042425.2 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]AJBUILD-01</SPAN>[/TD]
[TD="align: right"]16-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/16/2014 6:19:49 PM[/TD]
[TD]SC[/TD]
[TD]FIFTFIF-01</SPAN>[/TD]
[TD]Complete- Effective: LOan # (Quote)2774541 7-15-14 - Premium Financed Policy; IPFS[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]FIFTFIF-01</SPAN>[/TD]
[TD="align: right"]16-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/16/2014 9:51:46 AM[/TD]
[TD]MW[/TD]
[TD]BOWMJEF-01</SPAN>[/TD]
[TD]MW- Complete 07/29/2014 Loan # (Quote #) 000002703429. - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]BOWMJEF-01</SPAN>[/TD]
[TD="align: right"]16-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/17/2014 10:13:47 AM[/TD]
[TD]SC[/TD]
[TD]PRESCOI-01</SPAN>[/TD]
[TD]Complete SC- Eff: 08/01/2014 - Loan# 348375Premium Financed Policy for avaiation only-7/28[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]PRESCOI-01</SPAN>[/TD]
[TD="align: right"]17-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/17/2014 11:08:04 AM[/TD]
[TD]NE[/TD]
[TD]KELTCON-01</SPAN>[/TD]
[TD]NE - IN - Effective: - Premium Financed Policy NAC RSPS 8/28[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]KELTCON-01</SPAN>[/TD]
[TD="align: right"]17-Jul-14</SPAN>[/TD]
[TD]In Progress</SPAN>[/TD]
[/TR]
[TR]
[TD]7/17/2014 9:00:34 AM[/TD]
[TD]NE[/TD]
[TD]GRAHWIN-01</SPAN>[/TD]
[TD]Complete -NE- Effective: 7/1/14 Loan# (Quote#) 435849 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]GRAHWIN-01</SPAN>[/TD]
[TD="align: right"]17-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/18/2014 3:23:57 PM[/TD]
[TD]MW[/TD]
[TD]FMIATLA-01</SPAN>[/TD]
[TD]MW Complete TNR: Effective: 7/1/14 - Loan # (Quote #) 00000270745 Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]FMIATLA-01</SPAN>[/TD]
[TD="align: right"]18-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/21/2014 10:05:00 AM[/TD]
[TD]MW[/TD]
[TD]WENDWEL-01</SPAN>[/TD]
[TD]MW Complete - PFMP - Effective: 7/14/2014 Loan # (Quote #) 000002713174 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]WENDWEL-01</SPAN>[/TD]
[TD="align: right"]21-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/21/2014 11:45:49 AM[/TD]
[TD]SC[/TD]
[TD]MEYEJAB-03</SPAN>[/TD]
[TD]Completed SC - - Effective:1049765.1 Loan # 7/1/14-15 - Premium Financed Policy[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]MEYEJAB-03</SPAN>[/TD]
[TD="align: right"]21-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/21/2014 2:04:21 PM[/TD]
[TD]MW[/TD]
[TD]PACPIZZ-02</SPAN>[/TD]
[TD]MW Complete - Effective: 7/1/2014 - Loan # (Quote #) 00000270 Premium Financed Both HNOA Policies[/TD]
[TD]Open</SPAN>[/TD]
[TD]Action Required</SPAN>[/TD]
[TD]PACPIZZ-02</SPAN>[/TD]
[TD="align: right"]21-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
[TR]
[TD]7/21/2014 3:49:35 PM[/TD]
[TD]SC[/TD]
[TD]MARKCON-01</SPAN>[/TD]
[TD]Completed SC - Effective: 7-20-14 - Quote#2829508 Premium Financed Policies; IPFS; Down Payment Recv[/TD]
[TD]Open</SPAN>[/TD]
[TD]complete</SPAN>[/TD]
[TD]MARKCON-01</SPAN>[/TD]
[TD="align: right"]21-Jul-14</SPAN>[/TD]
[TD]Complete</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=2><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Similar threads

F
  • Question Question
Counting when record falls within a dynamically updating date range, additional matching criteria
Replies
1
Views
535
awoohaw
awoohaw
F
  • Question Question
Count # of values that fall within a certain date range
Replies
1
Views
567
RobP
R
F
  • Question Question
Looking to index some data based on multiple criteria, then index further data based on the 1st indexed data results
2
Replies
13
Views
897
KRice
K
Sufiyan97
  • Solved
VBA Filter Names from List One by One and then Copy filtered data v2
Replies
6
Views
177
Sufiyan97
Sufiyan97
A
  • Question Question
code to copy last row & exclude zero value of the data in last row for each name
Replies
0
Views
291
Abdo
A

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top