Spreadsheet: 803971d1667826817-extracting-data-from-excel-tables-sales-control
Sheet: Test

 | Date | I. D | Name | Invoice | Amount |  | Date | Name | I.D Number | Invoice | Transaction description | Amount
 | 44562 | A002 | Abi | 198 | -500 |  | 44866 | Abi | A002 | 1 | Sales | 3500
 | 44562 | A003 | Bigboy | 220 | 130 |  | 44866 | Rose | A001 | 2 | Sales | 3500
 |  |  |  |  |  |  | 44866 | Bigboy | A003 | 3 | Sales | 3500
 |  |  |  |  |  |  | 44870 | Abi | A002 | 4 | Sales | 5000
 |  |  |  |  |  |  | 44870 | Bigboy | A001 | 5 | Sales | 5000
 |  |  |  |  |  |  | 44870 | Rose | A003 | 6 | Sales | 5000
 | Bank | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance |  | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | Bank 1 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 100 |  | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 200
 | Bank 1 | 2022-11-05 00:00:00 | Abi | A002 | Sales |  | 23 | 3000 |  | 3100 |  | 2022-11-05 00:00:00 | Abi | A002 | Sales |  | 70 | 250 |  | 450
 | Bank 1 | 2022-11-05 00:00:00 | Bigboy | A003 | Sales |  | 24 | 2000 |  | 5100 |  | 2022-11-06 00:00:00 | Bigboy | A003 | Sales |  | 71 | 2000 |  | 2450
 | Bank 1 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300 | 4800 |  | 2022-11-06 00:00:00 | Rose | A001 | Sales |  | 72 | 3500 |  | 5950
 | Bank 1 | 2022-11-07 00:00:00 | Rose | A001 | Sales |  |  | 500 |  | 5300 |  | 2022-11-07 00:00:00 | Abi | A002 | Sales |  | 80 | 250 |  | 6200
 | Bank 1 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 4300 |  | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300 | 5900
 | Bank 1 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500 | 3800 |  | 2022-11-07 00:00:00 | Rose | A001 | Sales |  | 30 | 5000 |  | 10900
 | Bank 1 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300 | 3500 |  | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 9900
 | Bank 1 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 2500 |  | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500 | 9400
 | Bank 2 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 500 |  | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300 | 9100
 | Bank 2 | 2022-11-06 00:00:00 | Abi | A002 | Sales |  | 25 | 3500 |  | 4000 |  | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 8100
 | Bank 2 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300 | 3700
 | Bank 2 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 2700
 | Bank 2 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500 | 2200
 | Bank 2 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300 | 1900
 | Bank 2 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 900
 | Bank 3 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 130
 | Bank 3 | 2022-11-05 00:00:00 | Bigboy | A003 | Sales |  | 37 | 4000 |  | 4130
 | Bank 3 | 2022-11-07 00:00:00 | Abi | A002 | Sales |  | 40 | 1000 |  | 5130
 | Bank 3 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300 | 4830
 | Bank 3 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 3830
 | Bank 3 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500 | 3330
 | Bank 3 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300 | 3030
 | Bank 3 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000 | 2030