I am looking at a way to use a handheld bar code scanner and input the data into a worksheet.
What i need to do is the following
1: Scan cabinet serial number into cell C3 (9 characters in total for serial number)
2: Scan module 1 serial number into Cell D3 (12 characters in total for serial number)
3: Scan module 2 serial number into Cell E3 (12 characters in total for serial number)
each time the serial number is scanned i want to automatically jump to the next column and enter the serial number and jump to next column
once i have those 3 items scanned i then want to jump down to the next row and continue doing the same.
I know there has to be some VBA code here but i have no clue where to start.
Can someone help me out please