Barcode scanner

[JoboM]

Hi there,

I'm trying to code a spreadsheet to recognise codes scanned by barcode scanners. It would need to recognise one form of code (a letter followed by three numbers eg. A111), locate a cell with the matching code in it and select the cell to the right in the same row. Then with all other codes varieties, it would need to record that code into selected cells. Please help

Thank you all! Have a lovely day.​

 

[mole999]

what does your scan software output, csv, txt, xls .....? and how