hey everyone Im new to vba and creating a code to autofill some financial info, I would like to evaluate the cells in column 4, for a txt, then look in column 5 only for this example for an exact amount, ex"653" then place the specified answer in column 8. here is an example of my code I have so far it is working well just don't know how to evaluate the second condition, the line im having issues with is the last Select case, TD MORTGAGE
Dim finalrow As Integer
finalrow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 48 To finalrow
Select Case Cells(i, 4).Value
Case "Great-West Life PAY"
Cells(i, 8).Value = "GWL PAY"
Cells(i, 8).Interior.Color = 65535
Case "MAIL DEPOSIT"
Cells(i, 8).Value = "RENT PAYMENTS"
Cells(i, 8).Interior.Color = 65535
Case "EECOL ELECTRIC"
Cells(i, 8).Value = "WORK RELATED"
Cells(i, 8).Interior.Color = 65535
Case "AVIVA INS"
Cells(i, 8).Value = "Insurance Auto"
Cells(i, 8).Interior.Color = 65535
Case "TD MORTGAGE", Cells(i, 5) = 653
Cells(i, 8).Value = "mortgage Rockyford"
Cells(i, 8).Interior.Color = 65535
End Select
Next i
MsgBox ("newly added info has been automaticly updated and highlighted yellow")
End Sub