Hi there!

We have recently bought a USB barcode scanner (HX-US500) with the intention to be able to dispatch our orders quickly using Excel to populate the data.

For certain orders that are sent via a tracked service, we need to acquire the tracking details from the Royal Mail/Courier label. To save having multiple sheets for different dispatch types we would like to create a spreadsheet that can hold all the data for us. We would need the data to be entered in just two columns and to be populated as A1, B1 then A2, B2, A3, B3 and so on. Currently the scanner is set up to "enter" so is running A1 A2 A3 A4 etc. Unfortunately the manual it came with does not have a set up for the barcode to "tab" rather than "enter" and I cannot find any online manuals for this either.

I am sure that the answer is very simple, but not being an excel genius I need a little help setting this up!

Also, if anyone happens to know how to create a barcode with no data just a blank cell, or even a "N/A" barcode we'd love to know! (barcode novices!)

Thank you for your help in advance.