Moving cells

  • Thread starter Thread starter David Neustadt
  • Start date Start date
D

David Neustadt

I have a spreadsheet that has 6 columns (A thru F) where barcoded data
scanned by a barcode reader will be placed into my spreadsheet. In my
first row (row 1) I have a title bar that is frozen into place that
correlates to the different barcodes. My question is can Excel once a
cell has been populated with data automatically move to a desired row
and cell locaton?

For example:

Say my scanner reads a barcode that translates to a number of "10". I
press the enter enter button on the scanner which then transmits that
value of "10" to the spreadsheet to let's say cell E6.

What I would like to have happen is in the example above as soon as
cell E6 get's populated with a value (in my example I used "10") I
would like the next active cell for data popultion to be A7 (the next
row). Subsequently when E7 gets populated with data, I would like to
automatically have Excel move to A8.

I'm thinking there might be macro or some kind of function that needs
to be placed in column E that would say: "Right after columns E6,E7,E8
etc... receives a value, without hitting enter goto the next row
starting at column A.
 
Many barcode scanners interface by simulating keystrokes - so they send the
value followed by an enter (as if it were typed in). If you go into
tools=>Options, in the edit screen, you can set excels behavior for
receiving an enter to end an edit - set it to down.
 
Back
Top