View Single Post
  #1   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

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