Copy Paste Formula Issue Help!

[mikeeee]

I have a Formula =IF(H1803="YES","REPLY RECEIVED","") which puts Reply Received in a cell when YES is entered into another cell. The formula works great. It's just that I am applying it to a large file that already has YES in some of the cells and the corresponding cell already has a comment but not necessarily Reply Received. I am copying and pasting the formula down a column but I am having to skip all the cells that have a comment other than Reply Received. Is there a way to change the formula to make it disregard the cells that have a comment already or even better would be to just add Reply Received to the existing comment in the cell if one is present? Any ideas? Otherwise I am having to paste the formula into each empty cell and skip the prepopulated ones which is going to take a long time.

Thanks in advance!

 

[WarPigl3t]

There is no formula option because as you already stated, you'll have to manually skip cells that have other stuff in them.

a = "C"  'change C to the column that contains the formula.  You didn't specify the column in your message
lastRow = Range(a & Rows.Count).End(xlup).Row
i = 2  'if you do not have headers, i = 1
Do Until i > lastRow
     If Range(a & i).value = "" And Range("H" & i).value = "YES" Then
          Range(a & i).value = "REPLY RECIEVED"
     End If
     i = i + 1
Loop

 

[mikeeee]

Ok I'll try the code. Thanks!!!