Loop if one column value next column?

I am new to looping and am hoping someone might be able to help out. I have constructed a loop on column H. The problem is that I don't know how to loop the value into column I. Can anyone please help? I am posting the code here, but you will see that I have I2 hard coded, when the I cell should be the I on the same row as the H cell that is being evaluated.

Please Login or Register  to view this content.

Thanks~!

Not sure if this you what you want. It loops through each cell in column H to the last one with something in it.

Please Login or Register  to view this content.

Thank you for the reply. My only question is where the code is putting the result or answer. It needs to go into I for each row that there is an H value. It also needs to start at h2.

Make sense?

Thanks!

That did it! Thanks! I just had to change the last one ("No Writes Assigned") to also have that offset -1, because that was going into H.

Thank you so much!