Hi All, is it possible to scan a barcode and have the form auto-fill the item data eg. Code, Description, Brand & Description for a stock count purpose?
If so, how would I go about it?
I have two sheets 1) Item master sheet and 2) Count Sheet (Blank)
Item Master Sheet Column Order (BARCODE, CODE, BRAND, DESCRIPTION)
Count Sheet Column Order (Date(auto), Barcode, Code, Description, Brand, Qty)
Barcode (Scanning Manually)
Code (Auto-Fill)
Description (Auto-Fill)
Brand (Auto-Fill)
Qty (Manual)
User | Count |
---|---|
31 | |
27 | |
25 | |
21 | |
21 |