software

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?

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
quot;wickd03quot; wrote:

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

I am importing data from an engine scanning device. I can only import the
data to one cell. The data is just a number. 5 seconds later, another
number comes in, and i need this number to go into cell A2. Since I can not
tell the scanning device to put it in A2, can i have excel put it there
instead? The data is just a number...but it is a different number every 5
seconds and i need to be able to see all the numbers aligned in one column.

quot;CLRquot; wrote:

gt; Without a better understanding of your procedure, maybe you could use a
gt; ChangeEvent macro to step the cursor to the next cell with each entry, and
gt; turn it off when finished.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;wickd03quot; wrote:
gt;
gt; gt; how do i get data that is being imported in 5 second intervals to enter into
gt; gt; the next cell? The data enters A1, then 5 seconds later another number comes
gt; gt; in, and I want it to go to A2, then 5 seconds late another number comes in
gt; gt; and i want it to go into A3, and so on?

Thanks you sooooo much! I am going to give it a try.

quot;CLRquot; wrote:

gt; The ChangeEvent macro I mentioned should do the job.....as soon as a value
gt; shows up in the selected cell, the macro chirps and the cursor moves down one
gt; cell.......here's a quickie that might do it fo you....
gt;
gt; Private Sub Worksheet_Change(ByVal Target As Range)
gt; Application.ActiveCell.Select
gt; If Not Application.Selection(Target) Is Nothing Then
gt; Application.Selection.Offset(1, 0).Select
gt;
gt; End If
gt; End Sub
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;wickd03quot; wrote:
gt;
gt; gt; An engine scanner is plugging the number in A1. I can not get the scanner to
gt; gt; plug the data anywhere else. So, as a new number is generated from the scan,
gt; gt; it replaces the number in A1. I need a running list of all the numbers that
gt; gt; come in every 5 seconds. So logically, I would like the next number to go
gt; gt; into cell A2. Since I can not get the scanner to automatically enter the
gt; gt; next number into cell A2, I need to have Excel put it there. The numbers
gt; gt; come in every 5 seconds. The test only runs for about 3 minutes, so putting
gt; gt; them into one column would be ideal.
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Without a better understanding of your procedure, maybe you could use a
gt; gt; gt; ChangeEvent macro to step the cursor to the next cell with each entry, and
gt; gt; gt; turn it off when finished.
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;wickd03quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; how do i get data that is being imported in 5 second intervals to enter into
gt; gt; gt; gt; the next cell? The data enters A1, then 5 seconds later another number comes
gt; gt; gt; gt; in, and I want it to go to A2, then 5 seconds late another number comes in
gt; gt; gt; gt; and i want it to go into A3, and so on?

An engine scanner is plugging the number in A1. I can not get the scanner to
plug the data anywhere else. So, as a new number is generated from the scan,
it replaces the number in A1. I need a running list of all the numbers that
come in every 5 seconds. So logically, I would like the next number to go
into cell A2. Since I can not get the scanner to automatically enter the
next number into cell A2, I need to have Excel put it there. The numbers
come in every 5 seconds. The test only runs for about 3 minutes, so putting
them into one column would be ideal.

quot;CLRquot; wrote:

gt; Without a better understanding of your procedure, maybe you could use a
gt; ChangeEvent macro to step the cursor to the next cell with each entry, and
gt; turn it off when finished.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;wickd03quot; wrote:
gt;
gt; gt; how do i get data that is being imported in 5 second intervals to enter into
gt; gt; the next cell? The data enters A1, then 5 seconds later another number comes
gt; gt; in, and I want it to go to A2, then 5 seconds late another number comes in
gt; gt; and i want it to go into A3, and so on?

The ChangeEvent macro I mentioned should do the job.....as soon as a value
shows up in the selected cell, the macro chirps and the cursor moves down one
cell.......here's a quickie that might do it fo you....

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ActiveCell.Select
If Not Application.Selection(Target) Is Nothing Then
Application.Selection.Offset(1, 0).Select

End If
End Sub

hth
Vaya con Dios,
Chuck, CABGx3
quot;wickd03quot; wrote:

gt; An engine scanner is plugging the number in A1. I can not get the scanner to
gt; plug the data anywhere else. So, as a new number is generated from the scan,
gt; it replaces the number in A1. I need a running list of all the numbers that
gt; come in every 5 seconds. So logically, I would like the next number to go
gt; into cell A2. Since I can not get the scanner to automatically enter the
gt; next number into cell A2, I need to have Excel put it there. The numbers
gt; come in every 5 seconds. The test only runs for about 3 minutes, so putting
gt; them into one column would be ideal.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Without a better understanding of your procedure, maybe you could use a
gt; gt; ChangeEvent macro to step the cursor to the next cell with each entry, and
gt; gt; turn it off when finished.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;wickd03quot; wrote:
gt; gt;
gt; gt; gt; how do i get data that is being imported in 5 second intervals to enter into
gt; gt; gt; the next cell? The data enters A1, then 5 seconds later another number comes
gt; gt; gt; in, and I want it to go to A2, then 5 seconds late another number comes in
gt; gt; gt; and i want it to go into A3, and so on?