Carl -
How does that cell get updated?
If it's from a live feed from some online data source, then you probably
ought to post this in the Excel.Programming NG where you may find an answer.
If it's updated manually, then you need only write a worksheet change event.
Something like
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = 2 And .Row = 5 Then .Offset(0, 1).Value = Target.Value
End With
End Sub
