afmrubayat
New Member
- Joined
- Nov 29, 2009
- Messages
- 27
I want to retrieve Following Data from Sheet 1 to Sheet 2 based on date to be lookup, with top 20 with respective data.
When another date inserted in cell A1 of sheet 2 date will collect form Sheet 1 and Sheet 2 will be updated.
Sheet 1 will be like this with huge raw data:
[TABLE="******* 1440, align: center"]
<tbody>[TR]
[TD]BOID
[/TD]
[TD]BO Short Name
[/TD]
[TD]BO Type
[/TD]
[TD]18-Aug-16
[/TD]
[TD="colspan: 3"] 21-Aug-16
[/TD]
[TD="colspan: 3"] 22-Aug-16
[/TD]
[TD="colspan: 3"] 23-Aug-16
[/TD]
[TD="colspan: 3"] 24-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[TD="colspan: 3"] 28-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[/TR]
[TR]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]-
[/TD]
[TD]1,900
[/TD]
[TD]1,900
[/TD]
[TD]-
[/TD]
[TD]885,585
[/TD]
[TD]-
[/TD]
[TD]885,585
[/TD]
[TD]794,463
[/TD]
[TD]-
[/TD]
[TD]794,463
[/TD]
[TD]0.784%
[/TD]
[TD]1,011,256
[/TD]
[TD]1,289,035
[/TD]
[TD](277,779)
[/TD]
[TD]-0.274%
[/TD]
[/TR]
[TR]
[TD]1205720053777844
[/TD]
[TD]NLI Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]100,000
[/TD]
[TD]-
[/TD]
[TD]100,000
[/TD]
[TD]0.099%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1203490006793073
[/TD]
[TD]Shanta Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]6,500
[/TD]
[TD]-
[/TD]
[TD]6,500
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]90,000
[/TD]
[TD]6,500
[/TD]
[TD]83,500
[/TD]
[TD]0.082%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204220018014574
[/TD]
[TD]International Leasing Sec. Ltd
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]74,867
[/TD]
[TD]-
[/TD]
[TD]74,867
[/TD]
[TD]0.074%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204480020376044
[/TD]
[TD]IIDFC Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]450
[/TD]
[TD]-
[/TD]
[TD]450
[/TD]
[TD](450)
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]49,805
[/TD]
[TD]-
[/TD]
[TD]49,805
[/TD]
[TD]0.049%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1205660050208183
[/TD]
[TD]Trust Bank Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD](406)
[/TD]
[TD]40,550
[/TD]
[TD]-
[/TD]
[TD]40,550
[/TD]
[TD]0.040%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204490020697475
[/TD]
[TD]Bank Asia Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]5,000
[/TD]
[TD]800
[/TD]
[TD]5,000
[/TD]
[TD](4,200)
[/TD]
[TD]2,920
[/TD]
[TD]2,920
[/TD]
[TD]-
[/TD]
[TD]2,920
[/TD]
[TD]800
[/TD]
[TD]2,120
[/TD]
[TD]37,146
[/TD]
[TD]-
[/TD]
[TD]37,146
[/TD]
[TD]0.037%
[/TD]
[TD]20,850
[/TD]
[TD]9,920
[/TD]
[TD]10,930
[/TD]
[TD]0.011%
[/TD]
[/TR]
[TR]
[TD]1205050043090289
[/TD]
[TD]A. K. Khan Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]1,000
[/TD]
[TD]-
[/TD]
[TD]1,000
[/TD]
[TD](1,000)
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]1,837
[/TD]
[TD]1,837
[/TD]
[TD]-
[/TD]
[TD]34,000
[/TD]
[TD]-
[/TD]
[TD]34,000
[/TD]
[TD]0.034%
[/TD]
[TD]5,400
[/TD]
[TD]1,000
[/TD]
[TD]4,400
[/TD]
[TD]0.004%
[/TD]
[/TR]
[TR]
[TD]1204090016161981
[/TD]
[TD]SJIB SECURITIES LTD.
[/TD]
[TD]Individual
[/TD]
[TD]5,775
[/TD]
[TD]2,996
[/TD]
[TD]2,035
[/TD]
[TD]961
[/TD]
[TD]840
[/TD]
[TD]3,740
[/TD]
[TD](2,900)
[/TD]
[TD]11,803
[/TD]
[TD]2,996
[/TD]
[TD]8,807
[/TD]
[TD]26,085
[/TD]
[TD]840
[/TD]
[TD]25,245
[/TD]
[TD]0.025%
[/TD]
[TD]500
[/TD]
[TD]12,303
[/TD]
[TD](11,803)
[/TD]
[TD]-0.012%
[/TD]
[/TR]
[TR]
[TD]1201690000001163
[/TD]
[TD]SAR Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]120
[/TD]
[TD]3,000
[/TD]
[TD]3,120
[/TD]
[TD](120)
[/TD]
[TD]2,450
[/TD]
[TD]2,350
[/TD]
[TD]100
[/TD]
[TD]12,000
[/TD]
[TD]-
[/TD]
[TD]12,000
[/TD]
[TD]24,292
[/TD]
[TD]3,031
[/TD]
[TD]21,261
[/TD]
[TD]0.021%
[/TD]
[TD]18,300
[/TD]
[TD]15,000
[/TD]
[TD]3,300
[/TD]
[TD]0.003%
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 will be like this
[TABLE="******* 1284"]
<tbody>[TR]
[TD]Thursday, September 01, 2016
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="******* 545"]
<tbody>[TR]
[TD]
Sl. No.
[/TD]
[TD]BO ID
[/TD]
[TD]BO Name
[/TD]
[TD][/TD]
[TD]No. of shares
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1601970058396610
[/TD]
[TD]ICB Securities Trading Co.
[/TD]
[TD][/TD]
[TD]1,423,666
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1201530000003501
[/TD]
[TD]ICB
[/TD]
[TD][/TD]
[TD]1,371,366
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1201950000015755
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]1201950043531229
[/TD]
[TD]EBL SECURITIES LTD
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]533,500
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]1201820000005723
[/TD]
[TD]BRAC EPL Stock Brokerage Ltd.
[/TD]
[TD][/TD]
[TD]308,608
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1601670058396616
[/TD]
[TD]NTC A/C DRIEHAUS FEMF
[/TD]
[TD][/TD]
[TD]219,261
[/TD]
[/TR]
</tbody>[/TABLE]
Please help ASAP.
Regards,
Rubayat
afmrubayat@yahoo.com
When another date inserted in cell A1 of sheet 2 date will collect form Sheet 1 and Sheet 2 will be updated.
Sheet 1 will be like this with huge raw data:
[TABLE="******* 1440, align: center"]
<tbody>[TR]
[TD]BOID
[/TD]
[TD]BO Short Name
[/TD]
[TD]BO Type
[/TD]
[TD]18-Aug-16
[/TD]
[TD="colspan: 3"] 21-Aug-16
[/TD]
[TD="colspan: 3"] 22-Aug-16
[/TD]
[TD="colspan: 3"] 23-Aug-16
[/TD]
[TD="colspan: 3"] 24-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[TD="colspan: 3"] 28-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[/TR]
[TR]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]-
[/TD]
[TD]1,900
[/TD]
[TD]1,900
[/TD]
[TD]-
[/TD]
[TD]885,585
[/TD]
[TD]-
[/TD]
[TD]885,585
[/TD]
[TD]794,463
[/TD]
[TD]-
[/TD]
[TD]794,463
[/TD]
[TD]0.784%
[/TD]
[TD]1,011,256
[/TD]
[TD]1,289,035
[/TD]
[TD](277,779)
[/TD]
[TD]-0.274%
[/TD]
[/TR]
[TR]
[TD]1205720053777844
[/TD]
[TD]NLI Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]100,000
[/TD]
[TD]-
[/TD]
[TD]100,000
[/TD]
[TD]0.099%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1203490006793073
[/TD]
[TD]Shanta Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]6,500
[/TD]
[TD]-
[/TD]
[TD]6,500
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]90,000
[/TD]
[TD]6,500
[/TD]
[TD]83,500
[/TD]
[TD]0.082%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204220018014574
[/TD]
[TD]International Leasing Sec. Ltd
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]74,867
[/TD]
[TD]-
[/TD]
[TD]74,867
[/TD]
[TD]0.074%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204480020376044
[/TD]
[TD]IIDFC Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]450
[/TD]
[TD]-
[/TD]
[TD]450
[/TD]
[TD](450)
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]49,805
[/TD]
[TD]-
[/TD]
[TD]49,805
[/TD]
[TD]0.049%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1205660050208183
[/TD]
[TD]Trust Bank Securities Limited
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]406
[/TD]
[TD](406)
[/TD]
[TD]40,550
[/TD]
[TD]-
[/TD]
[TD]40,550
[/TD]
[TD]0.040%
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1204490020697475
[/TD]
[TD]Bank Asia Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]5,000
[/TD]
[TD]800
[/TD]
[TD]5,000
[/TD]
[TD](4,200)
[/TD]
[TD]2,920
[/TD]
[TD]2,920
[/TD]
[TD]-
[/TD]
[TD]2,920
[/TD]
[TD]800
[/TD]
[TD]2,120
[/TD]
[TD]37,146
[/TD]
[TD]-
[/TD]
[TD]37,146
[/TD]
[TD]0.037%
[/TD]
[TD]20,850
[/TD]
[TD]9,920
[/TD]
[TD]10,930
[/TD]
[TD]0.011%
[/TD]
[/TR]
[TR]
[TD]1205050043090289
[/TD]
[TD]A. K. Khan Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]1,000
[/TD]
[TD]-
[/TD]
[TD]1,000
[/TD]
[TD](1,000)
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]1,837
[/TD]
[TD]1,837
[/TD]
[TD]-
[/TD]
[TD]34,000
[/TD]
[TD]-
[/TD]
[TD]34,000
[/TD]
[TD]0.034%
[/TD]
[TD]5,400
[/TD]
[TD]1,000
[/TD]
[TD]4,400
[/TD]
[TD]0.004%
[/TD]
[/TR]
[TR]
[TD]1204090016161981
[/TD]
[TD]SJIB SECURITIES LTD.
[/TD]
[TD]Individual
[/TD]
[TD]5,775
[/TD]
[TD]2,996
[/TD]
[TD]2,035
[/TD]
[TD]961
[/TD]
[TD]840
[/TD]
[TD]3,740
[/TD]
[TD](2,900)
[/TD]
[TD]11,803
[/TD]
[TD]2,996
[/TD]
[TD]8,807
[/TD]
[TD]26,085
[/TD]
[TD]840
[/TD]
[TD]25,245
[/TD]
[TD]0.025%
[/TD]
[TD]500
[/TD]
[TD]12,303
[/TD]
[TD](11,803)
[/TD]
[TD]-0.012%
[/TD]
[/TR]
[TR]
[TD]1201690000001163
[/TD]
[TD]SAR Securities Limited
[/TD]
[TD]Individual
[/TD]
[TD]120
[/TD]
[TD]3,000
[/TD]
[TD]3,120
[/TD]
[TD](120)
[/TD]
[TD]2,450
[/TD]
[TD]2,350
[/TD]
[TD]100
[/TD]
[TD]12,000
[/TD]
[TD]-
[/TD]
[TD]12,000
[/TD]
[TD]24,292
[/TD]
[TD]3,031
[/TD]
[TD]21,261
[/TD]
[TD]0.021%
[/TD]
[TD]18,300
[/TD]
[TD]15,000
[/TD]
[TD]3,300
[/TD]
[TD]0.003%
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 will be like this
[TABLE="******* 1284"]
<tbody>[TR]
[TD]Thursday, September 01, 2016
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="******* 545"]
<tbody>[TR]
[TD]
Sl. No.
[/TD]
[TD]BO ID
[/TD]
[TD]BO Name
[/TD]
[TD][/TD]
[TD]No. of shares
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1601970058396610
[/TD]
[TD]ICB Securities Trading Co.
[/TD]
[TD][/TD]
[TD]1,423,666
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1201530000003501
[/TD]
[TD]ICB
[/TD]
[TD][/TD]
[TD]1,371,366
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1201950000015755
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]1201950043531229
[/TD]
[TD]EBL SECURITIES LTD
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]533,500
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]1201820000005723
[/TD]
[TD]BRAC EPL Stock Brokerage Ltd.
[/TD]
[TD][/TD]
[TD]308,608
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1601670058396616
[/TD]
[TD]NTC A/C DRIEHAUS FEMF
[/TD]
[TD][/TD]
[TD]219,261
[/TD]
[/TR]
</tbody>[/TABLE]
Please help ASAP.
Regards,
Rubayat
afmrubayat@yahoo.com
Last edited: