Advertisement
Tke439

Untitled

May 13th, 2020
527
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. With V_Sht
  2.    V_Sht.Select
  3.    For r = V_Sht.Cells(Rows.Count, 3).End(xlUp).Row To 3 Step -1
  4.       bounce = Cells(r, 1).Value
  5.       If WorksheetFunction.VLookup(bounce, Class_Rng, 2, False) <> "V" Then
  6.          Cells(r, 1).EntireRow.Delete
  7.       Else
  8.       End If
  9.    Next r
  10.    For a = V_Sht.Cells(Rows.Count, 3).End(xlUp).Row To 3 Step -1
  11.       For b = V_Sht.Cells(Rows.Count, 3).End(xlUp).Row To 3 Step -1
  12.          If Cells(a, 2).Value = Cells(b, 2).Value Then
  13.             Cells(a, 8).Value = WorksheetFunction.Sum(Cells(a, 8), Cells(b, 8))
  14.          Else
  15.          End If
  16.       Next b
  17.    Next a
  18. End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement