Barcode Scanner Data Input

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.

Hi Richard

Thank you for your very speedy response!

I have attached an example of the very simple spreadsheet that we would be looking for. The first sheet shows how we would like it to look. The second sheet is how it is actually coming though. In time we may want to add another scanner so that we could have separate sheets for each dispatcher, do you think that excel would work with that too?

Look forward to hearing from you!

Thanks Richard, that's great! We will have a play with this then, and fingers crossed it'll work well1 Appreciate your help with this!