-
Using a barcode scanner with Excel
Hi All,
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
Last edited by Mr_Mod; 05-12-2016 at 05:49 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules