that's great Art, thank you very much! Allow me one follow up question; if i
want to limit my list let's say to 100 outcomes, and when outcome 101
appears, outcome 1 is deleted and replaced by outcome 2 and so forth, hence
the list of 100 would change dynamically, how would i write that in a macro?

again, thanks very much!
Maurice

"Art" wrote:

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