Hi,

I have been wrestling with this for a while and am hoping someone can help.

I have a piece of trading software that can be connected to a spreadsheet. The software sends price data to cell A1 at half second intervals. Each time the price refreshes it overwrites the previous price in the same cell. I have been trying to export the price data from that cell into new cells so that for each half second refresh the price is copied into cell B1, B2, B3 etc so I end up with a single column containing a list of prices.

Is there a formula that will do this? Apologies if this is a basic question.

Thanks,

James