Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. For row = 2 To length
  2. If Sheets(wsname).Cells(row, column) = Sheets("Overview").Cells(ovrow, ovcol) Then
  3. counter = counter + 1
  4. End If
  5. Next row
  6. Sheets("Overview").Cells(ovrow, ovcol).Offset(0, 1).value = counter
  7. counter = 0
  8. If Sheets("Overview").Cells(ovrow, ovcol).Offset(1, 0).value = "" Then
  9. ovrow = 2
  10. ovcol = ovcol + 2
  11. column = column + 1
  12. Else
  13. ovrow = ovrow + 1
  14. End If
  15. Cells(ovrow, ovcol).Select
  16. Loop
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement