Results 1 to 15 of 15

running a loop on a few columns simultaneously?

Threaded View

losmi8 running a loop on a few... 02-13-2010, 07:06 PM
Mallycat Re: running a loop on a few... 02-13-2010, 07:23 PM
losmi8 Re: running a loop on a few... 02-13-2010, 07:51 PM
Mallycat Re: running a loop on a few... 02-13-2010, 08:30 PM
losmi8 Re: running a loop on a few... 02-13-2010, 08:42 PM
Mallycat Re: running a loop on a few... 02-13-2010, 09:19 PM
losmi8 Re: running a loop on a few... 02-13-2010, 08:48 PM
losmi8 Re: running a loop on a few... 02-13-2010, 08:57 PM
Mallycat Re: running a loop on a few... 02-13-2010, 09:14 PM
losmi8 Re: running a loop on a few... 02-13-2010, 09:20 PM
Mallycat Re: running a loop on a few... 02-13-2010, 09:30 PM
losmi8 Re: running a loop on a few... 02-13-2010, 09:50 PM
Mallycat Re: running a loop on a few... 02-13-2010, 10:28 PM
losmi8 Re: running a loop on a few... 02-14-2010, 05:30 AM
losmi8 Re: running a loop on a few... 02-14-2010, 05:31 AM
  1. #1
    Forum Contributor
    Join Date
    05-09-2009
    Location
    Chicago, US
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    188

    running a loop on a few columns simultaneously?

    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
    Last edited by losmi8; 02-13-2010 at 08:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1