excel problem (log current prices)

[alesh]

hi,
how can I save the values in constant change of the cells in other columns so as haven't only the last value visualized?

[Mitch]

Do you mean that you want to record the prices as they change so you can look back at what they were?

Do you want to do it for all selections or just 1?

[alesh]

1 Yes
2 For all selections.
I want to make the same thing that make individuial price, but for all selections.(sorry for the english)

[Mitch]

Do you just need the last few prices or do you need all of the information saving going back longer?

[alesh]

only last 10/15 minutes

[Mitch]

That would be a hell of a lot of trouble to code it off the top of my head, you would be better off having BA send the info for all the runners you want to separate sheets as well as the main one with all the runners on.