Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop and sum
Mike
Thanks so far but its giving me the sum in column D instead of the value in column s where the total is at least 3500 "Mike" wrote: Jenna, to save having lots of formula on your worksheet. right click the sheet tab and view code and paste this in. Add a button to run it. Sub doit() For i = 1 To Cells(Rows.Count, "C").End(xlUp).Row If Cells(i, "c").Value = 3500 Then Cells(i, "d").Value = Cells(i, "c").Value End If Next i End Sub "jenna" wrote: Please help i need a procedure to loop down column c and the first row where the sum is greater than 3500 put that amount in the adjacent column, then repeat from the next row down. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |