|Your goal is not clear.|
"if cell "D4" in "formula 1" is not equal to cell "D4" in "collection" , insert value of "D4" in "formula 1" in new row."
It is not clear whether you want the value in D4 currently in "formula 1" inserted in a new row or if you want the value in D4 inserted in a new row in "formula 1". It's also not clear into which sheet you want this value inserted.
In addition, you do not state when you want this insertion to take place. At the click of a button? When a sheet calculates? When a cell is manually changed in one or the other (or both?) sheets?
We need clearer and more complete requirements before we can offer any help.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.