Barcode Scanner coding

JoboM

New Member
Joined
May 26, 2015
Messages
40
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!!
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top