Hello,
I'm newbie in macro but i know something of programing.
My problem is somthing like this:
I have folder with multiple txt files (eg. 546.txt. 432.txt, 343.txt)
Content of every file have same formating but different data
546.txt
-----------------
Header
Number: 546
Value1: 1345 675
Value2: 323 245
Value3: 4322 343
432.txt
-----------------
Header
Number: 432
Value1: 32 444
Value2: 78766 245
Value3: 12 714
Importing delimiter that i have to used is "fixed width" because i cannot get good import. For Values row there is two numbers i need that are delimited with multiple spaces (not tabs).
From every file in working folder i want to import only rows Value
And would like to my excel sheet look like this:
Number Value1 Value2 Value2
432 32 78766 12
432 444 245 714
546 1345 323 4322
546 675 245 343
Can someone help me with this?
Bookmarks