Excel jumping to specific cells

[PhilBreau]

Hi all,

I have a bar code reader and need to scan serial numbers and other information from shipments. What I want to do is scan a number of bar codes from a box and then navigate to the next record. Right now, when the barcode reader scans a code, the information is typed followed by a carriage return. That works for a single column of codes. How do I get excel to navigate from row 1 > col1, col2, col3 then to to row 2 > col 1, col 2, col 3 for each scan?

Thank you

 

[SkipVought]

Hi,

I'd use VBA worksheet events.

Please repost in forum707 for a VBA solution.

 

[SkipVought]

I'd also suggest making your table a Structfured Table: insert > Tables > Table. With this feature, when you TAB within the table, you arrive at the next table cell, wrapping to the next line appropriately. In addition, I'd play around with Excel Options that would change the behavior of ENTER.