retrieve Following Data from Sheet 1 to Sheet 2 based on date to be lookup, with top 20

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:
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:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,216,176
Messages
6,129,316
Members
449,501
Latest member
Amriddin

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