Auto Fill

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)

0 1 78
1 REPLY 1
Top Labels in this Space