Hi, I am trying to populate the cells in column C. The range in column A changes every month so i am trying to find a way to dynamically count the amount of rows and then populate the counted cells in column C.
I've attached the picture and current code but can't figure out the rest.
Sub totn_if_example2()
For Each grades In Range("B2:B11")
If grades = "A" Or grades = "B" Then
grades.Offset(0, 1).Value = "Great work"
ElseIf grades = "C" Then
grades.Offset(0, 1).Value = "Needs Improvement"
ElseIf grades = "D" Then
grades.Offset(0, 1).Value = "Time for a Tutor"
Else
grades.Offset(0, 1).Value = " "
End If
Next grades
End Sub
I've attached the picture and current code but can't figure out the rest.
Sub totn_if_example2()
For Each grades In Range("B2:B11")
If grades = "A" Or grades = "B" Then
grades.Offset(0, 1).Value = "Great work"
ElseIf grades = "C" Then
grades.Offset(0, 1).Value = "Needs Improvement"
ElseIf grades = "D" Then
grades.Offset(0, 1).Value = "Time for a Tutor"
Else
grades.Offset(0, 1).Value = " "
End If
Next grades
End Sub