Insert Value When A Conditin is Met

[Admin]

Hi Ajit,

Welcome to ExcelFox !!

You can accomplish by inserting the formula in F4 and copied down,

=IFERROR(IF(D4="C","Same Day Cancel",""),"")

[Ajit]

Hi Admin!

Thanks very much for your reply. However, I'm looking for a VB code to do the same in an excel sheet. For eg., I want a loop to be written in VB code such that the loop looks at the whole of a range...say Cell C3 to C5000 and gives the output as "Same Day Cancel" in Col E for any of the cells found in Col C. I've managed to put the below loop in but doesn't work for a given range:

 Sub test()

If Range("C3:C5000").Value = "C" Then Range("E3:E5000").Value = "Same Day Cancel"

End Sub

It only works for a given Cell i.e C3 but not C3:C5000.

Thanks much for your help. Would you be able to help me put in a loop pls?

-Ajit