D
djenzovoort
I have a problem wich i cant seem to resolve.
Posted it before, but this is hopefully a better explanation;
Have a txt file with alot of data placed in one row (50.000 rows).
Across this row of data there is a constant value coming back called
SHEET
If imported in excel;
Example: SHEET 7K295 or SHEET 6H320 etc.
So find the string SHEET and when found copy the name
SHEET +7K295
I want to do this in a loop (the value SHEET could exist more than
100
times in that column).
And then also copy the 4th row below the string "SHEET", and the
9th,
the 14th and 19th and put those values like this in excel: (4,9,14,19
= always constant so this is the same for all data)
ColumA
SHEET 7K295
SHEET 6H320
etc
Column B
data 4th row below SHEET 7K295
data 4th row below SHEET 6H320
etc
Column C
data 9th row below SHEET 7K295
data 9th row below SHEET 6H320
etc
Column D
data 14th row below SHEET 7K295
data 14th row below SHEET 6H320
etc
Column E
data 19th row below SHEET 7K295
data 19th row below SHEET 6H320
etc
Hopefully someone can help!
Posted it before, but this is hopefully a better explanation;
Have a txt file with alot of data placed in one row (50.000 rows).
Across this row of data there is a constant value coming back called
SHEET
If imported in excel;
Example: SHEET 7K295 or SHEET 6H320 etc.
So find the string SHEET and when found copy the name
SHEET +7K295
I want to do this in a loop (the value SHEET could exist more than
100
times in that column).
And then also copy the 4th row below the string "SHEET", and the
9th,
the 14th and 19th and put those values like this in excel: (4,9,14,19
= always constant so this is the same for all data)
ColumA
SHEET 7K295
SHEET 6H320
etc
Column B
data 4th row below SHEET 7K295
data 4th row below SHEET 6H320
etc
Column C
data 9th row below SHEET 7K295
data 9th row below SHEET 6H320
etc
Column D
data 14th row below SHEET 7K295
data 14th row below SHEET 6H320
etc
Column E
data 19th row below SHEET 7K295
data 19th row below SHEET 6H320
etc
Hopefully someone can help!