Extract specific data from .txt file and put it into worksheet excel

[Lebbersmurf]

Hello people,

i am working in an chemical lab and for the moment i am struggling with following problem. On daily base, a lab instrument generates a txt file containing data. We print those data and put it afterwards manually into an existing excel file. Automatic importing of the txt file is not possible because we only enter the data that is necessary.

So in attachment you see a txt file with 5 lines containing data. Below you can see the first line:

u1;Fe ; 112.04;Pb ; 0;Cu ; 5.55;Si ; 12.71;Al ; 16.62;Sn ; 0;Cr ; 4.63;Ag ; 0;B ; 65.44;Zn ; 480.48;Mg ; 8.21;Ca ; 1091.28;P ; 418.2;Ba ; 0;V ; 0;Na ; 4.43;K ; 4.83;Mo ; 435.47;Sb ; 0;Mn ; 1.07;Ni ; 0;Cl ; 53.58;S ; 1464.64;Ti ; 0

It is my intention to put the data of some well defined components into excel at fixed places. An example: the first values of the line are "u1". The value noted after Fe, in this case 112.04, must be filled in under the column with header Fe1. The value noted after Zn, in this case 480.48, must be filled in under column with header Zn1. Etc for the other 2 elements.

The first values of the second line are "u2", which means that the values must be filled in under the columns containing (element)2 (example Fe2) etc.

Data must be added every day, so it is not the intention to overwrite the old data in excel but start at the first free row below the last data.

I guess my problem can be fixed with some VBA language or so, but i have tried it with no luck due to lack of experience.

Anyway, thanks beforehand for your help!