Spreadsheet: 739078d1625495089-vba-macro-to-get-amount-in-master-sheet-book1
Sheet: Data

 | 22025 | 22050 | 22102 | 22125 | 27125 | 28025 | 31560 | 34350 | Overall Result
# | 224.02 | -355405 |  | -618.64 | 0 | -60.93 |  |  | -355860.55
10001 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 22025
10002 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 22050
10003 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 22102
10005 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 22125
10010 |  |  |  |  | 0 | 0 |  |  | 0 |  | 27125
10011 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 28025
10012 |  |  |  |  | 0 | 0 |  |  | 0 |  | 31560
10013 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 |  | 34350
10014 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10015 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10016 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10017 |  |  |  |  | 0 | 0 |  |  | 0
10018 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10019 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10021 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
10022 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10036 |  |  |  |  | 0 |  |  |  | 0
10038 |  |  |  |  | 0 | 0 |  |  | 0
10041 |  |  |  |  | 0 | 0 |  |  | 0
10042 |  |  |  |  | 0 | 0 |  |  | 0
10046 |  |  |  |  | 0 | 0 |  |  | 0
10049 |  |  |  |  | 0 | 0 |  |  | 0
10050 |  |  |  |  | -351.51 | -88.53 |  |  | -440.04
10061 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10065 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10099 |  |  |  |  | -92.32 | -41.55 |  |  | -133.87
10102 | 0 |  |  |  |  |  |  |  | 0
10104 |  |  |  |  | 0 | 0 |  |  | 0
10108 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10109 | 0 |  | 0 | 0 | 0 |  |  |  | 0
10114 |  |  |  |  | 0 | 0 |  |  | 0
10121 | 0 |  |  |  | 0 | 0 |  |  | 0
10135 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10136 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10137 |  |  |  |  | -507.99 | -87.46 |  |  | -595.45
10138 |  |  |  |  | 0 | 0 |  |  | 0
10150 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10157 |  |  |  |  | 0 | 0 |  |  | 0
10158 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
10160 | 0 |  | 0 | 0 |  |  |  |  | 0
20001 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0
20005 |  |  |  |  | 0 | 0 |  |  | 0
20007 | 0 |  |  | 0 | 0 | 0 |  |  | 0
20008 |  |  |  |  | 0 | 0 |  |  | 0
20010 |  |  |  |  | 0 | 0 |  |  | 0
20014 |  |  |  |  | 0 | 0 |  |  | 0
20015 |  |  |  |  | 0 | 0 |  |  | 0
20016 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
20052 | -130.86 |  |  |  |  |  |  |  | -130.86
20056 |  |  |  |  | 0 | 0 |  |  | 0
20062 |  |  |  |  | -418.63 | -283.32 | -1305.5 | -1800.45 | -3807.9
20064 |  |  |  |  | 0 | 0 |  |  | 0
20068 |  |  | -24 |  | -15.55 | -17.92 | -247.11 | -1206.8 | -1511.38
20075 |  |  |  |  | 0 | 0 |  |  | 0
20076 |  |  |  |  | 0 | 0 |  |  | 0
30018 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
30019 | 0 |  | 0 | 0 |  |  |  |  | 0
30020 | 0 |  |  | 0 |  |  |  |  | 0
30023 |  |  |  |  |  | 0 |  |  | 0
30027 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0
30029 |  |  |  |  |  | 0 |  |  | 0
30069 |  |  |  |  | 0 | 0 |  |  | 0
30100 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
30228 |  |  |  |  | 0 | 0 |  |  | 0
30450 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
30464 | 0 |  |  |  |  |  |  |  | 0
30467 |  |  |  |  | 0 |  |  |  | 0
30476 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
30527 | 0 |  |  |  |  | 0 |  |  | 0
30552 | 0 |  |  |  |  | 0 |  |  | 0
30588 | 0 |  |  |  |  | 0 |  |  | 0
30589 | 0 |  |  |  | 0 | 0 |  |  | 0
30627 |  |  |  |  | 0 | 0 |  |  | 0
30628 | 0 |  | 0 |  |  | 0 |  |  | 0
30629 |  |  |  |  |  | 0 |  |  | 0
30644 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
40001 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
70001 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Overall Result | 93.16 | -355405 | -24 | -618.64 | -1386 | -579.71 | -1552.61 | -3007.25 | -362480.05