Spreadsheet: 186099d1349929768-need-a-macro-to-append-data-from-one-worksheet-to-another-in-the-same-workbook-master-copy
Sheet: Register

 |  |  |  |  | Client |  |  | Dividend |  | Total | Others |  | Total
 | [NAME] | Dr |  |  | No. | Holdings | Remark | SR | ZR | HDL | SR | ZR | HDL
1 | ASTA | TA | 1927799UK | 2 | 1927799 | 794 | Share | 0 | 0 | 0 | 0 | 0 | 0
2 | J3 | 1B | 29831UK | 2 | 29831 | 178373 | USD | 0 | 0 | 0 | 0 | 0 | 0
3 | J3 | 85 | 45267UK | 2 | 45267 | 6769 | Cash | 0 | 0 | 0 | 0 | 0 | 0
4 | J3 | R1 | 360057UK | 2 | 360057 | 6866 | Share | 0 | 0 | 0 | 0 | 0 | 0
5 | J3 | 85 | 45196UK | 2 | 45196 | 9800 | SGD | 0 | 0 | 0 | 0 | 0 | 0
6 | J3 | 85 | 45088UK | 2 | 45088 | 271547 | GBP | 0 | 0 | 0 | 0 | 0 | 0
7 | J3 | 5I | 13564UK | 2 | 13564 | 1479 | Share | 0 | 0 | 0 | 0 | 0 | 0
8 | J3 | X1 | 102236UK | 2 | 102236 | 2927 | Share | 0 | 0 | 0 | 0 | 0 | 0
9 | J3 | 5Z | 139638UK | 2 | 139638 | 6545 | Share | 0 | 0 | 0 | 0 | 0 | 0
10 | J3 | 5Z | 100292UK | 2 | 100292 | 6769 | Share | 0 | 0 | 0 | 0 | 0 | 0
11 | J3 | 6E | 26300UK | 2 | 26300 | 4323 | Share | 0 | 0 | 0 | 0 | 0 | 0
12 | J3 | 1B | 31100UK | 2 | 31100 | 11517 | Share | 0 | 0 | 0 | 0 | 0 | 0
13 | J3 | TA | 682049UK | 2 | 682049 | 38875 | USD | 0 | 0 | 0 | 0 | 0 | 0
14 | J3 | TA | 1924602UK | 2 | 1924602 | 10874 | Share | 0 | 0 | 0 | 0 | 0 | 0
15 | J3 | TA | 1930046UK | 2 | 1930046 | 7939 | Share | 0 | 0 | 0 | 0 | 0 | 0
16 | J3 | TA | 683303UK | 2 | 683303 | 10657 | Share | 0 | 0 | 0 | 0 | 0 | 0
17 | J3 | TA | 194161UK | 2 | 194161 | 1336 | Share | 0 | 0 | 0 | 0 | 0 | 0
18 | J3 | TA | 198263UK | 2 | 198263 | 87737 | Share | 0 | 0 | 0 | 0 | 0 | 0
19 | J3 | TA | 190479UK | 2 | 190479 | 39073 | Share | 0 | 0 | 0 | 0 | 0 | 0
20 | J3 | TA | 193770UK | 2 | 193770 | 831 | Share | 0 | 0 | 0 | 0 | 0 | 0
21 | J3 | TA | 297366UK | 2 | 297366 | 2376 | USD | 0 | 0 | 0 | 0 | 0 | 0
22 | J3 | TA | 196570UK | 2 | 196570 | 5451 | Share | 0 | 0 | 0 | 0 | 0 | 0
23 | J3 | TA | 197618UK | 2 | 197618 | 5544 | Share | 0 | 0 | 0 | 0 | 0 | 0
24 | J3 | TA | 197967UK | 2 | 197967 | 7108 | Share | 0 | 0 | 0 | 0 | 0 | 0
25 | J3 | TA | 294952UK | 2 | 294952 | 2078 | Share | 0 | 0 | 0 | 0 | 0 | 0
26 | J3 | TA | 1921038UK | 2 | 1921038 | 1050 | Share | 0 | 0 | 0 | 0 | 0 | 0
27 | J3 | TA | 190860UK | 2 | 190860 | 475 | Share | 0 | 0 | 0 | 0 | 0 | 0
28 | J3 | TA | 1903349UK | 2 | 1903349 | 100 | Share | 0 | 0 | 0 | 0 | 0 | 0
29 | J3 | TA | 293571UK | 2 | 293571 | 1109 | Share | 0 | 0 | 0 | 0 | 0 | 0
30 | J3 | TA | 195389UK | 2 | 195389 | 9482 | Share | 0 | 0 | 0 | 0 | 0 | 0
31 | J3 | TA | 294765UK | 2 | 294765 | 2484 | Share | 0 | 0 | 0 | 0 | 0 | 0
32 | J3 | TA | 1909450UK | 2 | 1909450 | 1552 | Share | 0 | 0 | 0 | 0 | 0 | 0
33 | J3 | TA | 1927799UK | 2 | 1927799 | 511 | Share | 0 | 0 | 0 | 0 | 0 | 0
34 | J3 | TA | 295082UK | 2 | 295082 | 4234 | Share | 0 | 0 | 0 | 0 | 0 | 0
35 | J3 | TA | 1902701UK | 2 | 1902701 | 200 | Share | 0 | 0 | 0 | 0 | 0 | 0
36 | J3 | TA | 1922790UK | 2 | 1922790 | 1026 | Share | 0 | 0 | 0 | 0 | 0 | 0
37 | J3 | TA | 1934041UK | 2 | 1934041 | 905 | Share | 0 | 0 | 0 | 0 | 0 | 0
38 | J3 | 5Z | 100226UK | 2 | 100226 | 29008 | SGD | 0 | 0 | 0 | 0 | 0 | 0
39 | J3 | 5Z | 100045UK | 2 | 100045 | 2976 | SGD | 0 | 0 | 0 | 0 | 0 | 0
40 | J3 | YT | 68572UK | 2 | 68572 | 57692 | Share | 0 | 0 | 0 | 0 | 0 | 0
41 | J3 | [NAME] | 344595UK | 2 | 344595 | 90 | GBP | 0 | 0 | 0 | 0 | 0 | 0
42 | J3 | 5Z | 62938UK | 2 | 62938 | 3882 | Share | 0 | 0 | 0 | 0 | 0 | 0
43 | J3 | YT | 60999UK | 2 | 60999 | 208 | SGD | 0 | 0 | 0 | 0 | 0 | 0
44 | J3 | MJ | 362016UK | 2 | 362016 | 6550 | SGD | 0 | 0 | 0 | 0 | 0 | 0
45 | J3 | JL | 241015UK | 2 | 241015 | 17816 | USD | 0 | 0 | 0 | 0 | 0 | 0
46 | J3 | CM | 142535UK | 2 | 142535 | 2556 | Share | 0 | 0 | 0 | 0 | 0 | 0
47 | J3 | 5C | 189000UK | 2 | 189000 | 34683 | Share | 0 | 0 | 0 | 0 | 0 | 0
48 | J3 | 5I | 13493UK | 2 | 13493 | 21241 | GBP | 0 | 0 | 0 | 0 | 0 | 0
49 | J3 | 1B | 31105UK | 2 | 31105 | 24157 | Share | 0 | 0 | 0 | 0 | 0 | 0
50 | J3 | 1B | 31550UK | 2 | 31550 | 9929 | Share | 0 | 0 | 0 | 0 | 0 | 0
51 | J3 | 5I | 13517UK | 2 | 13517 | 7978 | Share | 0 | 0 | 0 | 0 | 0 | 0
52 | J3 | 9V | 136726UK | 2 | 136726 | 129 | Share | 0 | 0 | 0 | 0 | 0 | 0
53 | J3 | TA | 176629UK | 2 | 176629 | 325 | USD | 0 | 0 | 0 | 0 | 0 | 0
54 | J3 | 5Z | 62962UK | 2 | 62962 | 3149 | Share | 0 | 0 | 0 | 0 | 0 | 0
55 | J3 | 5Z | 62993UK | 2 | 62993 | 8514 | GBP | 0 | 0 | 0 | 0 | 0 | 0
56 | J3 | K2 | 283788UK | 2 | 283788 | 1500 | SGD | 0 | 0 | 0 | 0 | 0 | 0
57 | J3 | 27 | 203995UK | 2 | 203995 | 50068 | Share | 0 | 0 | 0 | 0 | 0 | 0
58 | J3 | 2X | 383771UK | 2 | 383771 | 318 | Share | 0 | 0 | 0 | 0 | 0 | 0
59 | J3 | 81 | 49927UK | 2 | 49927 | 2568 | Share | 0 | 0 | 0 | 0 | 0 | 0
60 | J3 | 5I | 12985UK | 2 | 12985 | 23000 | SGD | 0 | 0 | 0 | 0 | 0 | 0
61 | J3 | 5I | 13421UK | 2 | 13421 | 18000 | USD | 0 | 0 | 0 | 0 | 0 | 0
62 | J3 | 52 | 255791UK | 2 | 255791 | 3965 | Share | 0 | 0 | 0 | 0 | 0 | 0
63 | J3 | 5S | 23704UK | 2 | 23704 | 3592 | Share | 0 | 0 | 0 | 0 | 0 | 0
64 | J3 | MJ | 371058UK | 2 | 371058 | 936 | USD | 0 | 0 | 0 | 0 | 0 | 0
65 | J3 | 5I | 13050UK | 2 | 13050 | 57143 | USD | 0 | 0 | 0 | 0 | 0 | 0
66 | J3 | 87 | 257020UK | 2 | 257020 | 113 | GBP | 0 | 0 | 0 | 0 | 0 | 0
67 | J3 | 68 | 44107UK | 2 | 44107 | 1490 | SGD | 0 | 0 | 0 | 0 | 0 | 0
68 | J3 | 2X | 186892UK | 2 | 186892 | 6810 | Share | 0 | 0 | 0 | 0 | 0 | 0
69 | J3 | 5Z | 100057UK | 2 | 100057 | 5230 | Share | 0 | 0 | 0 | 0 | 0 | 0
70 | J3 | C2 | 340779UK | 2 | 340779 | 9 | GBP | 0 | 0 | 0 | 0 | 0 | 0
71 | J3 | 3H | 188116UK | 2 | 188116 | 1059 | Share | 0 | 0 | 0 | 0 | 0 | 0
72 | J3 | 5Z | 100029UK | 2 | 100029 | 6445 | Share | 0 | 0 | 0 | 0 | 0 | 0
73 | J3 | 5Z | 288307UK | 2 | 288307 | 12658 | Share | 0 | 0 | 0 | 0 | 0 | 0
74 | J3 | 5Z | 100059UK | 2 | 100059 | 1020 | Share | 0 | 0 | 0 | 0 | 0 | 0
75 | J3 | LC | 260134UK | 2 | 260134 | 278 | Share | 0 | 0 | 0 | 0 | 0 | 0
76 | J3 | E8 | 354975UK | 2 | 354975 | 12621 | Share | 0 | 0 | 0 | 0 | 0 | 0
77 | J3 | 20 | 207095UK | 2 | 207095 | 374 | Share | 0 | 0 | 0 | 0 | 0 | 0
78 | J3 | 5Z | 139650UK | 2 | 139650 | 4514 | Share | 0 | 0 | 0 | 0 | 0 | 0
79 | J3 | 4Y | 333725UK | 2 | 333725 | 35717 | Share | 0 | 0 | 0 | 0 | 0 | 0
80 | J3 | 5T | 19594UK | 2 | 19594 | 3613 | Share | 0 | 0 | 0 | 0 | 0 | 0
81 | J3 | RW | 185072UK | 2 | 185072 | 45000 | USD | 0 | 0 | 0 | 0 | 0 | 0
82 | J3 | WF | 102531UK | 2 | 102531 | 5035 | USD | 0 | 0 | 0 | 0 | 0 | 0
83 | J3 | 5Z | 139711UK | 2 | 139711 | 1229 | Share | 0 | 0 | 0 | 0 | 0 | 0
84 | J3 | 5Z | 100043UK | 2 | 100043 | 6962 | SGD | 5 | 0 | 5 | 0 | 0 | 0
85 | J3 | SK | 33344UK | 2 | 33344 | 28928 | SGD | 0 | 0 | 0 | 0 | 0 | 0
86 | J3 | AM | 315046UK | 2 | 315046 | 608 | SGD | 0 | 0 | 0 | 0 | 0 | 0
87 | J3 | 5I | 13128UK | 2 | 13128 | 7125 | USD | 0 | 0 | 0 | 0 | 0 | 0
88 | J3 | T5 | 245543UK | 2 | 245543 | 8537 | Share | 0 | 0 | 0 | 0 | 0 | 0
89 | J3 | 4B | 136149UK | 2 | 136149 | 2918 | Share | 0 | 0 | 0 | 0 | 0 | 0
90 | J3 | B2 | 337376UK | 2 | 337376 | 4083 | Share | 0 | 0 | 0 | 0 | 0 | 0
91 | J3 | 66 | 43403UK | 2 | 43403 | 48 | Share | 0 | 0 | 0 | 0 | 0 | 0
92 | J3 | CT | 312577UK | 2 | 312577 | 3190 | Share | 0 | 0 | 0 | 0 | 0 | 0
93 | J3 | 5P | 29103UK | 2 | 29103 | 17873 | GBP | 0 | 0 | 0 | 0 | 0 | 0
94 | J3 | 66 | 43252UK | 2 | 43252 | 51 | SGD | 0 | 0 | 0 | 0 | 0 | 0
95 | J3R | JM | 640543UK | 2 | 640543 | 17015 | Share | 5 | 0 | 0 | 0 | 0 | 0
96
97
98
99
100 | J3 |  |  |  | [NAME]
101 |  |  |  |  | DOPT2
102
103
104
105 | J3R |  |  |  | [NAME]
106 |  |  |  |  | DOPT2
107
108
109
110 |  |  |  |  |  | 318
111 |  |  |  |  |  | 1383242