hi guys i have two tables in different sheet on sheet 1 is where i want to put the total of the amount that i input on table 2 on sheet 2 depending on name on column B and the header of the table, like the sample table below
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Table 1 on sheet 1 | ||||||||
2 | 1 | 2 | 3 | 4 | 5 | 6 | |||
3 | Cash | 100 | 50 | ||||||
4 | Receivable | 50 | |||||||
5 | Payable | 60 | |||||||
6 | |||||||||
7 | |||||||||
8 | Data on sheet 2 | ||||||||
9 | 1 | 2 | 3 | 4 | 5 | 6 | |||
10 | Cash | 20 | |||||||
11 | Receivable | 60 | |||||||
12 | Payable | ||||||||
13 | Cash | 30 | 50 | ||||||
14 | cash | 50 | |||||||
15 | Payable | 50 | |||||||
16 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1