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:
<tbody>
</tbody>
Sheet 2 will be like this
<tbody>
</tbody>
<tbody>
</tbody>
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:
BOID | BO Short Name | BO Type | 18-Aug-16 | 21-Aug-16 | 22-Aug-16 | 23-Aug-16 | 24-Aug-16 | % Free Float | 28-Aug-16 | % Free Float | ||||||||||
Credits | Debits | Movement | Credits | Debits | Movement | Credits | Debits | Movement | Credits | Debits | Movement | Credits | Debits | Movement | ||||||
1201950000015747 | EBL Securities Limited | - | - | 100 | 100 | - | 1,900 | 1,900 | - | 885,585 | - | 885,585 | 794,463 | - | 794,463 | 0.784% | 1,011,256 | 1,289,035 | (277,779) | -0.274% |
1205720053777844 | NLI Securities Limited | - | - | - | - | - | - | - | - | - | - | - | 100,000 | - | 100,000 | 0.099% | - | - | - | 0.000% |
1203490006793073 | Shanta Securities Limited | - | - | - | - | - | 6,500 | - | 6,500 | - | - | - | 90,000 | 6,500 | 83,500 | 0.082% | - | - | - | 0.000% |
1204220018014574 | International Leasing Sec. Ltd | - | - | - | - | - | - | - | - | - | - | - | 74,867 | - | 74,867 | 0.074% | - | - | - | 0.000% |
1204480020376044 | IIDFC Securities Limited | Individual | 450 | - | 450 | (450) | - | - | - | - | - | - | 49,805 | - | 49,805 | 0.049% | - | - | - | 0.000% |
1205660050208183 | Trust Bank Securities Limited | - | - | 406 | - | 406 | - | - | - | - | 406 | (406) | 40,550 | - | 40,550 | 0.040% | - | - | - | 0.000% |
1204490020697475 | Bank Asia Securities Limited | Individual | 5,000 | 800 | 5,000 | (4,200) | 2,920 | 2,920 | - | 2,920 | 800 | 2,120 | 37,146 | - | 37,146 | 0.037% | 20,850 | 9,920 | 10,930 | 0.011% |
1205050043090289 | A. K. Khan Securities Limited | Individual | 1,000 | - | 1,000 | (1,000) | - | - | - | 1,837 | 1,837 | - | 34,000 | - | 34,000 | 0.034% | 5,400 | 1,000 | 4,400 | 0.004% |
1204090016161981 | SJIB SECURITIES LTD. | Individual | 5,775 | 2,996 | 2,035 | 961 | 840 | 3,740 | (2,900) | 11,803 | 2,996 | 8,807 | 26,085 | 840 | 25,245 | 0.025% | 500 | 12,303 | (11,803) | -0.012% |
1201690000001163 | SAR Securities Limited | Individual | 120 | 3,000 | 3,120 | (120) | 2,450 | 2,350 | 100 | 12,000 | - | 12,000 | 24,292 | 3,031 | 21,261 | 0.021% | 18,300 | 15,000 | 3,300 | 0.003% |
<tbody>
</tbody>
Sheet 2 will be like this
Thursday, September 01, 2016 |
<tbody>
</tbody>
Sl. No. | BO ID | BO Name | No. of shares | |
1 | 1601970058396610 | ICB Securities Trading Co. | 1,423,666 | |
2 | 1201530000003501 | ICB | 1,371,366 | |
3 | 1201950000015755 | EBL Securities Limited | 660,000 | |
4 | 1201950043531229 | EBL SECURITIES LTD | 660,000 | |
5 | 1201950000015747 | EBL Securities Limited | 533,500 | |
6 | 1201820000005723 | BRAC EPL Stock Brokerage Ltd. | 308,608 | |
7 | 1601670058396616 | NTC A/C DRIEHAUS FEMF | 219,261 |
<tbody>
</tbody>
Please help ASAP.
Regards,
Rubayat
afmrubayat@yahoo.com
Last edited: