Hi all. I am trying to run a loop on a few columns simultaneously, from the last row to the top (well, until the 2nd row).
So I have a few columns of data, A through I, and the number of rows they populate changes all the time.
So how would I run a loop that will check for the following:
If a certain row in Column F is greater than the previous row in column F by 1.5times, then in that same row, if number in Column B is greater than number in E, the code should put the the value of E in a new column, lets say M (in the same row)
I know that sounds very confusing, but is that even possible? I am playing with loops, and I can only do very simple loops where I define a range, like
Sub runningdown()
Dim milosRow As Long
With Range("H:H")
For mRow = .Rows.Count To 1 Step -1
If .Cells(mRow).Value > 3 Then .Cells(mRow, 7) = .Cells(mRow).Value
Next mRow
End With
End Sub
I need to see what a more complicated loop would look, like the above description of what I need. That is the only way I could learn, is if I see it and then dissect it and just learn from it.
Thank you all. If what I have above isn't even possible, please let me know
Bookmarks