Filling a cell based on the content of another cell
For i = 2 To ActiveSheet.Cells(Rows.Count, "E").End(xlUp).Row
If Cells(i, 5).Text = "DAY CARE" Then
Cells(i, 18) = "INFANT"
Else
Cells(i, 18) = "CHILD"
End If
Next
"Lonnie M." wrote:
Hi, thanks for your feedback, I just tested it again and it worked just
fine for me.
If I placed "infant" in "E2", "R2" correctly placed "Daycare"
If I placed "child" in "E3", "R3" correctly placed "Preschool"
If I placed "6" in "E4", "R4" correctly placed "Preschool"
I'm not sure what went wrong for you. You may want to make sure that
the value in the else statement wasn't changed to "infant"
HTH--Lonnie M.
|