how to loop through rows in excel

[sugaprasad]

Hi eveyone,

i have a requirement. its to find a specific word ('MO') in a notepad and copy certain values from the line where that specific word found and paste those values into an excel cell. the specific word 'MO' occurs multiple times in the notepad. for each occurrence the corresponding values must be pasted into a next row in the excel. so I am using a Do until to find the word 'MO'.

But I got stuck in pasting the next occurrence of values into the subsequent rows. I guess i should use For loop in the code to get this through.
But i don't know where.

Can someone please help

My code so far

Please Login or Register  to view this content.

[GC Excel]

Hello,

Try this code:

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[JimBobBowie]

Hi,

You need to track the current row and add one to it each time you paste in new data. They this code. It should start on row 1 each time and write data down until complete.

Please Login or Register  to view this content.

[sugaprasad]

Hi thank you so much. But there is one issue i face with the code you have suggested. the value for 'ART' is getting pasted in cell A1. but the value of ID is getting pasted into B2 instead of B1

can you please advice

screenshot for your reference

output.jpg

[sugaprasad]

Thank you Norie & JimBobBowie.

Norie's code works great you are a life saver

[GC Excel]

Hello,

Hi thank you so much. But there is one issue i face with the code you have suggested. the value for 'ART' is getting pasted in cell A1. but the value of ID is getting pasted into B2 instead of B1

It's because your original code was:

Please Login or Register  to view this content.

otherwise I would have suggested this :

Please Login or Register  to view this content.