Import text file into excel and split data in specific sheets

Hello,
I attached my .txt data file named "data". I also attach the excel file, to help you to understand what i really need.
I need a VBA solution for import the informations in excel.
The challenge is to split this data into multiple sheets, by "Node Name".

for example:
in sheet 1, will be imported data from node name 17GHEB, the sheet name will become 17GHEB.
so on

best regards, i hope somebody can help me

Please Login or Register  to view this content.

Thanks yudlugar! that code works really fine. but that informations are copied into one column.
I need to get that data in separate columns. In fact, i need to get only day, volume and energy. can be done?
Anyway, i appreciate your effort, you are really good!
Best regards,
Ionut

Try this

Please Login or Register  to view this content.

I came up with this:

Please Login or Register  to view this content.

Did you change the filepath?

Place both Excel and text file in the same folder and try again.

It is working here.

a stupid question: if i want to import other column (for example: "pressure" from that .txt file, what should i change into the jindon's code?
i looked at the code 1 hour today and i still feel stupid...
thanks again, you are doing a great job!

thanks man! you rulllzzzzzzz!

Can you just add one space after 3 rd asterisk?

Please Login or Register  to view this content.

Thx, u r big in japan!
have a nice day!

jindon, could you explain the logic of this code?
i understand it about 90%, but something it's not very clear to me. for instance, i try to extend that code for 6 columns:

Sheets(t).Cells(n, 1).Resize(, 6).Value = _
[{"day","Flow hrs.","presure","diff","Energy kWh","Volume m3"}]
End If
If n > 0 Then
.Pattern = "^ *(\d+) *(\d+\.\d{2}).\D+ *(\d+\.\d{2})*(\d+\.\d{2}).\D+ +(\d+\.\d{2}).* (\d+\.\d{2}) *(\d+\.\d{2})*(\d+\.\d{2}) *$"

but, it appear a blank on "pressure" column. what i did wrong?
it seems that i am not smart enough...

Please Login or Register  to view this content.

finally i get it!! i understand the meaning of code! you are great man, i really apreciate your work! thanks very much again, best regards!