Microsoft Office Forums - View Single Post - [Solved] If else statement-Need help with coding

rsrasc · 10-29-2015, 01:57 PM

Just wondering if the below code could be combined or simplified.

Thank you for your assistance and cooperation

Code:

Sub MetIndividualGoal1()

If Range("E5").Value >= Range("F5").Value Then

    Range("H5").Value = "Yes"
    
    Else
    Range("H5").Value = "No"
    
End If

End Sub

Sub MetIndividualGoal2()

If Range("E6").Value >= Range("F6").Value Then

    Range("H6").Value = "Yes"
    
    Else
    Range("H6").Value = "No"
    
End If

End Sub

Sub MetIndividualGoal3()

If Range("E7").Value >= Range("F7").Value Then

    Range("H7").Value = "Yes"
    
    Else
    Range("H7").Value = "No"
    
End If

End Sub