Spreadsheet: 882083d1730358837-need-formula-sheet-2-to-take-the-data-from-the-sheet-1-unorganized-excel-data-allanortiz-sheet-2-1-spill-365-aligw
Sheet: SHEET 2 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formula here to take    data from sheet 1
 |  | Journal No | Source Code | Original Number |  |  | Journal Date | Distribution Reference |  |  | Reference |  | Debit Amount |  |  |  |  |  | Credit Amount |  | Balance |  |  |  |  |  |  | CT Number | Site ID | Total Price
 |  | 24010033 | CNSJV | CT-1111 |  |  | 14/01/2024 | Consumable Transaction CT-1111 |  |  |  |  | 605.5 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | Nescafe 01Ctn / 12*200g | 380
 |  | 24010043 | CNSJV | CT-1244 |  |  | 14/01/2024 | Consumable Transaction CT-1244 |  |  |  |  | 530.43 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1111 | Red Tea CTN 24/100 | 196
 |  | 24010044 | CNSJV | CT-1245 |  |  | 14/01/2024 | Consumable Transaction CT-1245 |  |  |  |  | 758.95 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1111 | Sugar 10 KG | 29.5
 |  | 24010045 | CNSJV | CT-1516 |  |  | 14/01/2024 | Consumable Transaction CT-1516 |  |  |  |  | 407.2 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1244 | Cardamom | 130.43
 |  | 24010046 | CNSJV | CT-1590 |  |  | 14/01/2024 | Consumable Transaction CT-1590 |  |  |  |  | 1628 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1244 | Coffee Mate CTN/12*900g | 400
 |  | 24010047 | CNSJV | CT-1769 |  |  | 14/01/2024 | Consumable Transaction CT-1769 |  |  |  |  | 668 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1245 | [NAME] | 480
 |  | 24010138 | CNSJV | CT-1770 |  |  | 28/01/2024 | Consumable Transaction CT-CT-1770 |  |  |  |  | 558.27 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1245 | Cloves for Coffee | 52.95
 |  | Totals |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1245 | Nescafe 01Ctn / 12*200g | 226
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Sugar 10 KG | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Dates For Patient 01Ctn / 3.5Kg | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Turkish Coffee | 78.86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Paper Tray Cover | 104.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | [NAME] | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Coffee Mate CTN/12*900g | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Nescafe 01Ctn / 12*200g | 188
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Dates For Patient 01Ctn / 3.5Kg | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Red Tea CTN 24/100 | 196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Nescafe 01Ctn / 12*200g | 376
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Sugar 10 KG | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1770 | [NAME] | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1770 | Turkish Coffee | 78.27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | 5156.35