Import .dbf file, and process its contents.

[burgonyapure]

Hi guys !

I am new to excel programming, yet I have work to be done, so if you could help me out it would be well appreciated.

I have several .dbf files, and they look like this in excel:

401003 <tbody> </tbody>	EUR <tbody> </tbody>	10 <tbody> </tbody>	2019.04.01 <tbody> </tbody>	200 <tbody> </tbody>	62200 <tbody> </tbody>	311,00 <tbody> </tbody>
401004 <tbody> </tbody>	RON <tbody> </tbody>	10 <tbody> </tbody>	2019.04.01 <tbody> </tbody>	121 <tbody> </tbody>	7464 <tbody> </tbody>	61,69 <tbody> </tbody>
401005 <tbody> </tbody>	GBP <tbody> </tbody>	10 <tbody> </tbody>	2019.04.01 <tbody> </tbody>	300 <tbody> </tbody>	108750 <tbody> </tbody>	362,50 <tbody> </tbody>

<tbody>
</tbody>

Obviously a lot longer, but you get the point.

All I need to do, is a button to click, and than loop through all the .dbf files, do a =SUMIF(D1:D3;D1;F1:F3) and paste the result into another sheet wich looks like:

2019.04.01	My result here
2019.04.02	My result here
2019.04.03	My result here

<tbody>
</tbody>

After this close, the .dbf file, open the next one, and do the same, but the data calculated must be inserted into it's corresponding sheet.

Any ideas?