lookup and copy certain value in a loop
Hello,
I have a problem wich i cant seem to resolve.
Have a txt file with alot of data placed in one row. There is also the
value SHEET.
If imported in excel;
I want excel to find the value SHEET and if found copy the 5th, 10th
and 15th row under the value SHEET .. and paste it in colum B , C,
D ...
I want to do this in a loop (the value SHEET could exist more than 100
times in that column).
Hope someone can point me in the right direction.
Thanks in advance!
J.Lemmens
|