Advance filter

[sohaila]

I want extract data in particular dates with advance filter
can any body help me ?

Date	Particulars	Balance		Require data
1-Jan-00​	Opening Balance	10000​		10-Jul-17​
4-Jul-17​	Cash deposited	12000​		11-Jul-17​
10-Jul-17​	Cash deposited	30340​		11-Jul-17​
10-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	7851902​		14-Jul-17​
10-Jul-17​	Cheque Cleared ( #103118249 )	7846152​		14-Jul-17​
10-Jul-17​	Transfer by Ch.#103118217 (Dt. 14-Jun-2017)	7842959​		14-Jul-17​
10-Jul-17​	Cash deposited	7856519​		25-Jul-17​
10-Jul-17​	Outward Chq#63 Cleared From HABIB BANK LIMITED	7876295​		26-Jul-17​
10-Jul-17​	Outward Chq#17 Cleared From HABIB BANK LIMITED	7896295​		27-Jul-17​
19-Jul-17​	Outward Chq#95660333 Cleared From MEEZAN BANK LIMITED	30000​		27-Jul-17​
19-Jul-17​	Outward Chq#10276332 Cleared From BANK AL HABIB	54000​		1-Aug-17​
20-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	10686093​		3-Aug-17​
20-Jul-17​	Cheque Cleared ( #103118238 )	10635071​		7-Aug-17​
20-Jul-17​	Cash deposited	10647071​		15-Aug-17​
20-Jul-17​	Outward Chq#5655667 Cleared From BANK ALFALAH LIMITED	10668531​
20-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-84400​
20-Jul-17​	Outward Chq#93598470 Cleared From BANK ALFALAH LIMITED	-66400​
20-Jul-17​	Outward Chq#10276331 Cleared From BANK AL HABIB	-27980​
20-Jul-17​	Outward Chq#75726945 Cleared From HABIB BANK LIMITED	-7640​
20-Jul-17​	Outward Chq#102 Cleared From HABIB BANK LIMITED	10000​
21-Jul-17​	Cash deposited	25000​
21-Jul-17​	Cash deposited	62800​
21-Jul-17​	Cheque 103118258 encashed (Dt. 21-Jul-2017).	59300​
21-Jul-17​	Transfer by Ch.#103118257 (Dt. 19-Jul-2017)	54030​
21-Jul-17​	Cheque 103118259 encashed (Dt. 21-Jul-2017).	52392​
21-Jul-17​	Bill(s) Received by Cheque # 103118265 (20311-714-205184)	-78577​
21-Jul-17​	Transfer by Ch.#94827879 (Dt. 20-Jul-2017)	921423​
21-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11674354​
21-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-16520​
21-Jul-17​	Transfer by Ch.#102592782 (Dt. 20-Jul-2017)	10600​
21-Jul-17​	Cheque book Chrages Debited	10000​
22-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11700874​
22-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
24-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11700874​
24-Jul-17​	Cheque Cleared ( #103118260 )	11696717​
24-Jul-17​	Cheque Cleared ( #103118264 )	11689365​
24-Jul-17​	Outward Chq#97248228 Cleared From SUMMIT BANK LIMITED	11701365​
24-Jul-17​	Outward Chq#739703 Cleared From ALLIED BANK LIMITED	11706485​
24-Jul-17​	Outward Chq#97140659 Cleared From SUMMIT BANK LIMITED	11733605​
24-Jul-17​	Outward Chq#470 Cleared From HABIB BANK LIMITED	11751065​
24-Jul-17​	Return of Outward Clearing Chq#14441613 From SILK BANK LTD	11737065​
24-Jul-17​	Return of Outward Clearing Chq#14441613 From SILK BANK LTD	11751065​
24-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
24-Jul-17​	Outward Chq#50665680 Cleared From UNITED BANK LIMITED	22600​
25-Jul-17​	Outward Chq#48851008 Cleared From STANDARD CHARTERED BANK	68340​
25-Jul-17​	Outward Chq#45632503 Cleared From UNITED BANK LIMITED	88680​
25-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-1.2E+07​
25-Jul-17​	Cash deposited	-1.2E+07​
25-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	8933​
25-Jul-17​	Cash deposited	28933​
25-Jul-17​	Cheque Cleared ( #103118261 )	-3560​
25-Jul-17​	Cash deposited	10000​
25-Jul-17​	Outward Chq#1648351025 Cleared From MCB BANK LIMITED	37120​
26-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11867932​
26-Jul-17​	Outward Chq#29329437 Cleared From THE BANK OF KHYBER	11895052​
26-Jul-17​	Outward Chq#1309806174 Cleared From BANK OF PUNJAB	11915392​
26-Jul-17​	Cheque Cleared ( #103118262 )	11833403​
26-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
27-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11833403​
27-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-43500​
27-Jul-17​	Cash deposited	-30000​
27-Jul-17​	Transfer by Ch.#2693380 (Dt. 27-Jul-2017)	-12000​
27-Jul-17​	Outward Chq#99426034 Cleared From BANK ALFALAH LIMITED	-2000​
27-Jul-17​	Outward Chq#99334197 Cleared From MEEZAN BANK LIMITED	25120​
27-Jul-17​	Outward Chq#99152955 Cleared From ALLIED BANK LIMITED	50320​
27-Jul-17​	Outward Chq#1642344786 Cleared From MCB BANK LIMITED	71320​
27-Jul-17​	Outward Chq#91072617 Cleared From MEEZAN BANK LIMITED	76970​
27-Jul-17​	Transfer by Ch.#2693379 (Dt. 27-Jul-2017)	88970​
28-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11965873​
28-Jul-17​	Cash deposited	11977633​
28-Jul-17​	Outward Chq#2871700 Cleared From ALLIED BANK LIMITED	12004753​
28-Jul-17​	Outward Chq#10132090 Cleared From BANK AL HABIB	12029613​
28-Jul-17​	Outward Chq#14441613 Cleared From SILK BANK LTD	12043613​
28-Jul-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
29-Jul-17​	FUND TRF FROM MULTIPLE A/C TO CURRENT A/C	12043613​
29-Jul-17​	FUND TRF FORM CURRENT A/C TO MULTIPLER A/C	85000​
29-Jul-17​	Transfer by Ch.#103118269 (Dt. 29-Jul-2017)	10000​
31-Jul-17​	Cheque 103118266 encashed (Dt. 31-Jul-2017).	-205172​
31-Jul-17​	WHT U/S231-A On CWD Chq# 103118266 DT( 31/07/2017 )	-205818​
31-Jul-17​	Return of Outward Clearing Chq#882692961 From FAYSAL BANK LIMITED	-217818​
31-Jul-17​	Return of Outward Clearing Chq#882692961 From FAYSAL BANK LIMITED	-205818​
31-Jul-17​	Outward Chq#11007457 Cleared From BANK AL HABIB	-181818​
31-Jul-17​	Outward Chq#11007458 Cleared From BANK AL HABIB	-141818​
31-Jul-17​	FUND TRF FROM CURENT A/C TO MULTIPLER A/C	-205818​
31-Jul-17​	Cash deposited	-203818​
31-Jul-17​	Outward Chq#98847015 Cleared From MEEZAN BANK LIMITED	-190823​
31-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	-1.2E+07​
31-Jul-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	-25380​
31-Jul-17​	Cash deposited	-18600​
31-Jul-17​	Cash deposited	-12600​
31-Jul-17​	Cash deposited	10000​
1-Aug-17​	Outward Chq#97239787 Cleared From SUMMIT BANK LIMITED	37120​
1-Aug-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	11921290​
1-Aug-17​	Cheque Cleared ( #103118268 )	11861290​
1-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	11827390​
1-Aug-17​	Cash deposited	11845390​
1-Aug-17​	Outward Chq#96820902 Cleared From MEEZAN BANK LIMITED	11879290​
1-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-17120​
1-Aug-17​	Cash deposited	10000​
2-Aug-17​	Outward Chq#4078265 Cleared From DUBAI ISLAMIC BANK	43100​
2-Aug-17​	Cash deposited	61100​
2-Aug-17​	Transfer by Ch.#103632932 (Dt. 01-Aug-2017)	91340​
2-Aug-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	12021650​
2-Aug-17​	Cheque Cleared ( #103118218 )	12019405​
2-Aug-17​	Cheque Cleared ( #103118226 )	12017043​
2-Aug-17​	Return of Outward Clearing Chq#154 From HABIB BANK LIMITED	12003483​
2-Aug-17​	Return of Outward Clearing Chq#154 From HABIB BANK LIMITED	12017043​
2-Aug-17​	Outward Chq#1311296311 Cleared From BANK OF PUNJAB	12030903​
2-Aug-17​	Outward Chq#226 Cleared From HABIB BANK LIMITED	12058023​
2-Aug-17​	Outward Chq#106 Cleared From HABIB BANK LIMITED	12085143​
2-Aug-17​	Outward Chq#772236 Cleared From BANK ALFALAH LIMITED	12105483​
2-Aug-17​	Outward Chq#97234880 Cleared From SUMMIT BANK LIMITED	12128083​
2-Aug-17​	Outward Chq#94479978 Cleared From MEEZAN BANK LIMITED	12141643​
2-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPERL A/C	-35200​
2-Aug-17​	Web Funds transfered from ABDUL QADIR	-12600​
2-Aug-17​	Transfer by Ch.#103086040 (Dt. 02-Aug-2017)	10000​
3-Aug-17​	FUND TRF FROM MUTIPLER A/C TO CURRENT A/C	12186843​
3-Aug-17​	Cheque Cleared ( #103118267 )	12174915​
3-Aug-17​	Outward Chq#14433045 Cleared From SILK BANK LTD	12193628​
3-Aug-17​	Cash deposited	12205628​
3-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-57820​
3-Aug-17​	Outward Chq#580854 Cleared From UNITED BANK LIMITED	-30700​
3-Aug-17​	Outward Chq#99273073 Cleared From BANK ALFALAH LIMITED	-10360​
3-Aug-17​	Transfer by Ch.#100996081 (Dt. 24-Jul-2017)	10000​
3-Aug-17​	Outward Chq#11136391 Cleared From BANK AL HABIB	30000​
4-Aug-17​	Outward Chq#154 Cleared From HABIB BANK LIMITED	43560​
4-Aug-17​	Outward Chq#882009568 Cleared From FAYSAL BANK LIMITED	70680​
4-Aug-17​	Outward Chq#53612562 Cleared From UNITED BANK LIMITED	75880​
4-Aug-17​	Outward Chq#28616444 Cleared From JS BANK LIMITED	100830​
4-Aug-17​	Outward Chq#80370691 Cleared From BANK ALFALAH LIMITED	129079​
4-Aug-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	12392527​
4-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	-106866​
4-Aug-17​	Outward Chq#47742588 Cleared From STANDARD CHARTERED BANK	-19540​
4-Aug-17​	Outward Chq#84990020 Cleared From BANK ALFALAH LIMITED	-1540​
4-Aug-17​	Outward Chq#11161963 Cleared From BANK AL HABIB	10000​
5-Aug-17​	Outward Chq#97062703 Cleared From BANK ALFALAH LIMITED	37120​
5-Aug-17​	FUND TRF FROM MULTIPLER A/C TO CURRENT A/C	12536513​
5-Aug-17​	Transfer by Ch.#104303160 (Dt. 05-Aug-2017)	12559113​
5-Aug-17​	Cash deposited	12580413​
5-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
7-Aug-17​	FUND TRF FROM MULTIPLIER ACCOUNT TO CURRENT ACCOUNT	12509393​
7-Aug-17​	Cash deposited	12521393​
7-Aug-17​	Cash deposited	12533393​
7-Aug-17​	Cheque Cleared ( #103118197 )	12489098​
7-Aug-17​	Cheque Cleared ( #103118270 )	12414098​
7-Aug-17​	Cheque Cleared ( #103118271 )	12339098​
7-Aug-17​	Outward Chq#28048248 Cleared From JS BANK LIMITED	12366218​
7-Aug-17​	Outward Chq#97160691 Cleared From SUMMIT BANK LIMITED	12386558​
7-Aug-17​	Outward Chq#18210582 Cleared From Albaraka Bank	12406898​
7-Aug-17​	fund trf to multiplier account from current account as per instruction	10000​
8-Aug-17​	Outward Chq#27 Cleared From HABIB BANK LIMITED	37120​
8-Aug-17​	Outward Chq#1310257455 Cleared From BANK OF PUNJAB	50980​
8-Aug-17​	Outward Chq#239070 Cleared From ALLIED BANK LIMITED	74980​
8-Aug-17​	Outward Chq#93870430 Cleared From ALLIED BANK LIMITED	95320​
8-Aug-17​	Outward Chq#2845750 Cleared From MEEZAN BANK LIMITED	121820​
8-Aug-17​	FUND TRF TO CURRENT ACCOUNT FROM MULTIPLIER ACCOUNT AS PER PARTY INSTRUCTION	12589738​
8-Aug-17​	Cash deposited	12591763​
8-Aug-17​	Transfer by Ch.#105073679 (Dt. 03-Aug-2017)	12586799​
8-Aug-17​	WHT U/S231-A On CWD Chq# 103118273 DT( 08/08/2017 )	12586638​
8-Aug-17​	WHT U/S231-A On CWD Chq# 103118272 DT( 08/08/2017 )	12586614​
8-Aug-17​	Cheque 103118274 encashed (Dt. 08-Aug-2017).	12583114​
8-Aug-17​	Cheque 103118273 encashed (Dt. 08-Aug-2017).	12533114​
8-Aug-17​	Cheque 103118272 encashed (Dt. 08-Aug-2017).	12525054​
8-Aug-17​	Transfer by Ch.#105073680 (Dt. 03-Aug-2017)	12440788​
8-Aug-17​	Cash deposited	12449788​
8-Aug-17​	Transfer by Ch.#103384318 (Dt. 04-Aug-2017)	12468208​
8-Aug-17​	Transfer by Ch.#104372588 (Dt. 11-Jul-2017)	12480345​
8-Aug-17​	Transfer by Ch.#103118275 (Dt. 03-Aug-2017)	11217906​
8-Aug-17​	FUND TRF TO MULTIPLIER ACCOUNT AS PER PARTY INSTRUCTION	11193906​
8-Aug-17​	Outward Chq#1647337584 Cleared From M.C.B BANK LIMITED	11209026​
8-Aug-17​	Cash deposited	11222526​
8-Aug-17​	Return of Outward Clearing Chq#18772026 From BANK ALFALAH LIMITED	11204526​
8-Aug-17​	Return of Outward Clearing Chq#18772026 From BANK ALFALAH LIMITED	11222526​
8-Aug-17​	FUND TRF TO MULTIPLIER ACCOUNT FROM CURRENT ACCOUNT AS PER PARTY INSTRUCTION	26500​
8-Aug-17​	Outward Chq#3621654 Cleared From PRIME COMMERCIAL BANK LIMITED	36500​
8-Aug-17​	Outward Chq#3286504 Cleared From BANK ALFALAH LIMITED	56840​
9-Aug-17​	FUND TRF TO CD ACCOUNT FROM MULTIPLIER ACCOUNT AS PER INSTRUCTION	11276866​
9-Aug-17​	Cheque Cleared ( #105073678 )	11219330​
9-Aug-17​	Outward Chq#25767649 Cleared From THE BANK OF KHYBER	11241930​
9-Aug-17​	FUND TRF TO MULTIPLIER ACCOUNT FROM CD ACCOUNT AS PER PARTY INSTRUCTION	-133760​
9-Aug-17​	Outward Chq#19465256 Cleared From MEEZAN BANK LIMITED	-113420​
9-Aug-17​	Outward Chq#50284113 Cleared From UNITED BANK LIMITED	-93080​
9-Aug-17​	Outward Chq#49145810 Cleared From STANDARD CHARTERED BANK	-72740​
9-Aug-17​	Cash deposited	-52400​
9-Aug-17​	Outward Chq#10752234 Cleared From BANK AL HABIB	-39800​
9-Aug-17​	Outward Chq#340768 Cleared From SUMMIT BANK LIMITED	-17120​
9-Aug-17​	Return of Outward Clearing Chq#1321628 From BANK ALFALAH LIMITED	-39120​
9-Aug-17​	Return of Outward Clearing Chq#1321628 From BANK ALFALAH LIMITED	-17120​
9-Aug-17​	Return of Outward Clearing Chq#1310015933 From BANK OF PUNJAB	-37460​
9-Aug-17​	Return of Outward Clearing Chq#1310015933 From BANK OF PUNJAB	-17120​
9-Aug-17​	Outward Chq#19670039 Cleared From MEEZAN BANK LIMITED	10000​
10-Aug-17​	FUND TRF TO CD ACCOUNT FROM MULTIPLIER ACCOUNT AS PER PARTY INSTRUCTION	11385690​
10-Aug-17​	Cheque Cleared ( #105073681 )	11373690​
10-Aug-17​	Cheque Cleared ( #105073683 )	11354870​
10-Aug-17​	Cash deposited	11360870​
10-Aug-17​	Transfer by Ch.#103210376 (Dt. 10-Aug-2017)	11381390​
10-Aug-17​	Outward Chq#7145764 Cleared From BANK ALFALAH LIMITED	11401730​
10-Aug-17​	Outward Chq#93687027 Cleared From ALLIED BANK LIMITED	11424330​
10-Aug-17​	Outward Chq#14629550 Cleared From SILK BANK LTD	11444670​
10-Aug-17​	Outward Chq#117205 Cleared From SUMMIT BANK LIMITED	11469621​
10-Aug-17​	Outward Chq#7145765 Cleared From BANK ALFALAH LIMITED	11496741​
10-Aug-17​	fund trf to multiplier account from cd account as per party instruction	-36120​
10-Aug-17​	Outward Chq#9876852 Cleared From SUMMIT BANK LIMITED	10000​
11-Aug-17​	FUND TRF TO CD A/C FROM MULTIPLIER ACCOUNT AS PER INSTRUCTION	11542861​
11-Aug-17​	Transfer by Ch.#94760680 (Dt. 10-Aug-2017)	11560501​
11-Aug-17​	Cheque 105073705 encashed (Dt. 11-Aug-2017).	11557232​
11-Aug-17​	Transfer by Ch.#3897653 (Dt. 10-Aug-2017)	11570792​
11-Aug-17​	Outward Chq#146592 Cleared From SUMMIT BANK LIMITED	11597912​
11-Aug-17​	Outward Chq#1591193726 Cleared From MCB BANK LIMITED	11618252​
11-Aug-17​	Outward Chq#1321628 Cleared From BANK ALFALAH LIMITED	11640252​
11-Aug-17​	Transfer by Ch.#105073706 (Dt. 09-Aug-2017)	11240252​
11-Aug-17​	Return of Outward Clearing Chq#32 From HABIB BANK LIMITED	11213132​
11-Aug-17​	Return of Outward Clearing Chq#32 From HABIB BANK LIMITED	11240252​
11-Aug-17​	FUND TRF TO MULTIPLIER ACCOUNT FROM CD ACCOUNT AS PER PARTY INSTRUCTION	10000​
11-Aug-17​	Outward Chq#308594 Cleared From STANDARD CHARTERED BANK	70816​
12-Aug-17​	FUND TRF TO CD A/C FROM MULTIPLIER A/C AS PER INSTRUCTIONS	11301068​
12-Aug-17​	FUND TRF FROM CURRENT A/C TO MULTIPLER A/C	10000​
15-Aug-17​	FUND TRF TO CD A/C FROM MULTIPLIER ACCOUNT AS PER INSTRUCTION	11301068​
15-Aug-17​	Cash deposited	11319068​
15-Aug-17​	Cash deposited	11322188​
15-Aug-17​	Cheque Cleared ( #105073676 )	8484987​
15-Aug-17​	Cash deposited	8496987​
15-Aug-17​	Outward Chq#88443839 Cleared From FAYSAL BANK LIMITED	8524187​
15-Aug-17​	Cash deposited	8534187​
15-Aug-17​	Outward Chq#70 Cleared From HABIB BANK LIMITED	8568087​
15-Aug-17​	FUND TRF TO MULTIPLIER ACCOUNT FROM CD ACCOUNT AS PER INSTRUCTION	10000​
15-Aug-17​	Outward Chq#97255452 Cleared From MEEZAN BANK LIMITED	22140​
15-Aug-17​	Outward Chq#31330741 Cleared From JS BANK LIMITED	42140​
15-Aug-17​	Outward Chq#74189727 Cleared From HABIB BANK LIMITED	78140​
15-Aug-17​	Outward Chq#126175 Cleared From ASKARI BANK LTD.	102140​

 

[mohadin]

Hi
Assume you data in A1..
Try

Sub test
    Range("G1:H1").Value = Range("A1:B1").Value
    Range("A1:E231").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
        "E1:E" & Cells(Rows.Count, 5).End(xlUp).Row), CopyToRange:=Range("G1:H1")

End Sub

 

[James006]

Hi,
You can turn on your macro recorder ... and go through your process once ... to get an initial "VBA translation" of your actions

 

[shinigamilight]

Sub work()
        Range("A1").CurrentRegion.AdvancedFilter xlFilterCopy, Range("E1:E15"), Range("I1")
End Sub

 

[sohaila]

Thanks for your response but is this Possible in worksheet advance filter method without vba.

 

[James006]

Hi,

If you want to learn How to Use Advanced Filter

How to Set Up Excel Advanced Filter Criteria - Examples

Excel advanced filter examples take you beyond basic steps. See how to filter top records, blank cells, and more. Written steps, videos, Excel workbook

www.contextures.com