View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] djenzovoort@gmail.com is offline
external usenet poster
 
Posts: 16
Default lookup and copy certain value in a loop

Thanks for the reply, thought i explaned it in good detail cause the
problem isn't that complicated;

The txt file is a huge file (about 50.000 lines);

I need to collect some data from this txt file, i have found a
constant wich i want to look for:

SHEET 7K295 or SHEET 6H320 etc.

Now i want Excel to find the string SHEET and when found copy the name
SHEET +7K295
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:

ColumA
B C
D E

SHEET 7K295 data 4th row data
9th row data 14th row data 19th row
SHEET 6H320 data 4th row data
9th row data 14th row data 19th row
etc
etc

Hope this is a good explenation,