Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. For i = 3 To 300
  2. x = 0
  3. j = i - 1
  4. If Cells(i, 2).Value = "FX" And Not IsEmpty(Cells(i - 1, 1).Value) Then
  5. Do While Cells(j, 4).Value <> ""
  6. x = Cells(j, 4).Value + x
  7. j = j - 1
  8. Loop
  9. End If
  10. Cells(i, 4).vlue = x
  11. Next i
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement