Show result of loop after each iteration

[Hoozits]

I am using a for...next loop and would simply like to display the result of that loop in a cell on a spreadsheet at each iteration. Any help would be greatly appreciated. Here is an example:

for j = 101 to 111
for k = 1 to 100
if cells(k,3)="Mr. Excel" then
cells(j, 1)=cells(k,2)
end if
next k
next j

The problem I am having is that only the last value for k is being used to produce results in cells(j,1). The j-loop works fine, but the k-loop is not. Thanks in advance for any help.

 

[Oaktree]

I don't think you need the j loop.

j = 101
for k = 1 to 100 
if cells(k,3)="Mr. Excel" then 
cells(j, 1)=cells(k,2) 
j = j + 1
end if 
next k

But, why would j only go from 101 to 111? Or is there Mr. Excel only in every 10th row or similar...?

 

[Hoozits]

You are absolutely correct. Your suggested improvement worked like a charm. I hope you feel greatly appreciated for this because you are. Many thanks.