Formulas can't push but they can pull.

In M4 enter =IF(G4="Closed",G4,"")

If you're looking for VBA solution.

Sub test()
With ActiveSheet
If .Range("G4") = "closed" Then
..Range("M4") = "closed"
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 14:28:05 -0800, mzwayne
wrote:

Hello! I would like to have a formula that will automatically populate into a
cell. For example:

if G4 says "Closed" then insert "Closed" in M4.

Can anyone tell me if this is possible and how to do it??

Thanks!