Hi there legends!
I'm trying to build a spreadsheet to manage logistics information. The information will be captured through a barcode scanner. I've already played around with the scanner and it records the information into a cell in excel, but I would like it to be more automated.
I need excel to recognise two varieties of code. The first to be scanned would always consist of 1 alphabetical character, followed by 3 numerical characters; for example:
A111 or P739
The second code could be of any variety, but would not be of the structure shown above. Could you help me to code the spreadsheet so that it recognises the first code and locates the same code on the spreadsheet, then selects the cell in the same row but column immediately to the right. Then when the second barcode is scanned, inputs that information into the selected cell.
I'm at loss here guys
please help!!
I'm trying to build a spreadsheet to manage logistics information. The information will be captured through a barcode scanner. I've already played around with the scanner and it records the information into a cell in excel, but I would like it to be more automated.
I need excel to recognise two varieties of code. The first to be scanned would always consist of 1 alphabetical character, followed by 3 numerical characters; for example:
A111 or P739
The second code could be of any variety, but would not be of the structure shown above. Could you help me to code the spreadsheet so that it recognises the first code and locates the same code on the spreadsheet, then selects the cell in the same row but column immediately to the right. Then when the second barcode is scanned, inputs that information into the selected cell.
I'm at loss here guys
please help!!
