Help: Copy refreshed data in cell to another cell as a column

[nov]

Hi to all,

I'm new in Excell VBA programming and i have the following problem. I' am using DDE Server to import my data to Excel let say A1. The Data is refreshed every 5 seconds i need to copy the content of the cell /A1/ every 3 seconds to another cell let say B1, next 3 seconds to B2 then B3.... to Bn as a column.

How do i make this?

Thank you

Regards

[Leith Ross]

Hello Nov,

Is there a reason you could not copy the data from A1 into column B as soon as A1 has been updated? Repost and let me know.

Thanks,
Leith Ross