Macro to collect data from a text file into an excel file

Hi all,
I am pretty new to this forum and request help on programming using vb in excel.

I have the results of an analysis in text format (attached: suma.txt) which needs to be summarised in an excel file. I would like to have macro developed to capture the data in any specific format.

The data of interest starts with the text 'Baseline draft:' and you can see that the data is repeated 13 times in the file. The data that is reported between the above text and the next repeat is of interest. if I take the first set, the values i need to capture in my summary table are: 5.699, 3.928, Fwd, 1.76, Stbd, 5.38, 4.872, 18519, 36.45, 5.38, 2.947, 48.59, 2.453. Similarly the corresponding values for the next 12 sets are also to be summarised.

I am a novice to vb and has seen threads which touches similar requirement. Appreciate if someone can help with this.

Thanking you in advance

regards

Thank you for the reply/ideas.

I knew this would be tricky. All 13 blocks have the same consistent text markers with the required data occuring either alongside or below it. I am not sure which way to go but I will give both your ideas a try.

Regards