Hello everyone,
I have something I want to do, but I have no idea where to start, so here is the problem :
I have many excel files :
On the file a.xls I have this
<tbody>
</tbody>
On the file b.xls I have this :
<tbody>
</tbody>
On the c.xls file, i would like to look into the a.xls file and the b.xls file to check the name, and then sum up the corresponding column :
It would give me in the end :
<tbody>
</tbody>
(If there are some unique names between the excels it just retrieve the original values).
Is it possible to do so ? If yes thank you for your help It'd save me.
Thanks again,
Arkine
I have something I want to do, but I have no idea where to start, so here is the problem :
I have many excel files :
On the file a.xls I have this
Igor | 10 | 20 | 10 |
Patrick | 30 | 30 | 10 |
Bob | 20 | 20 | 20 |
<tbody>
</tbody>
On the file b.xls I have this :
Igor | 20 | 30 | 40 |
Bob | 10 | 10 | 10 |
Edward | 20 | 20 | 20 |
<tbody>
</tbody>
On the c.xls file, i would like to look into the a.xls file and the b.xls file to check the name, and then sum up the corresponding column :
It would give me in the end :
Igor | 30 | 50 | 50 | ||||
Patrick | 30 | 30 | 10 | ||||
Bob | 30 | 30 | 30 | ||||
Edward | 20 | 20 | 20 | ||||
<tbody>
</tbody>
(If there are some unique names between the excels it just retrieve the original values).
Is it possible to do so ? If yes thank you for your help It'd save me.
Thanks again,
Arkine
Last edited: