Maurice,

The only way I can think of is to use a macro. If that's okay, consider the
following.
The formula is in B2. The list of outcomes will be in C. The input cell is
A2.

You need to enter a macro into the sheet that this data is on. The
following macro should do it:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A2") Then
Range("c65536").End(xlUp).Offset(1) = Range("B2")
End If
End Sub


"Maurice" wrote:

I am working with a formula in which the value of one of the inputcells
changes dynamically (stock quote). What can i do to automatically put the
changing outcome of the formula in a series in a colum?

Can anybody help me out ?

Maurice
Amsterdam, The Netherlands