Export Data from Cell at Set Intervals

[jrarmstrong4]

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

[shg]

Try this:

Please Login or Register  to view this content.

Code goes in the relevant sheet module.

Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
3. Paste the code in the window
4. Press Alt+Q to close the VBE and return to Excel