I have been tasked with a project to create an Excel sheet for Stock Purposes. I have a Wired Handheld Scanner, and I have been able to scan a Barcode to Excel, and for it to show up in the selected Cell.
I have the following Columns in my Excel Sheet;
Column A = Barcode (in text form)
Column B = Product Name (at the moment I will be manually inputting the names of the Product)
Column C = Quantity
I am wanting to know if it is possible to do the following;
Product 123 is located in Row 15, it has 15 items
I want to Scan the Barcode for Product 123 and then scan +10, this should then update the quantity value of this product to 25.
I'm not great with Visual Basic, so please excuse my ignorance.
I have the following Columns in my Excel Sheet;
Column A = Barcode (in text form)
Column B = Product Name (at the moment I will be manually inputting the names of the Product)
Column C = Quantity
I am wanting to know if it is possible to do the following;
- Scan a Product Barcode. If it already exists in Column A, for example A13, then move cursor to Column C13 (ready for quantity update). If it doesn't exist in Column A, then add it to the first free cell in Column A.
- Scan +10 or -10, and for this value to populate the relevant Quantity cell related to that Product Barcode. (I don't know how I would create a Scanning Sheet which would have the "+" "-" barcode and the numbers barcodes respectively, any help would be great.)
Product 123 is located in Row 15, it has 15 items
I want to Scan the Barcode for Product 123 and then scan +10, this should then update the quantity value of this product to 25.
I'm not great with Visual Basic, so please excuse my ignorance.
