Without a better understanding of your procedure, maybe you could use a
ChangeEvent macro to step the cursor to the next cell with each entry, and
turn it off when finished.

Vaya con Dios,
Chuck, CABGx3






"wickd03" wrote:

how do i get data that is being imported in 5 second intervals to enter into
the next cell? The data enters A1, then 5 seconds later another number comes
in, and I want it to go to A2, then 5 seconds late another number comes in
and i want it to go into A3, and so on?