Barcode is a smart way to keep track of your inventory. It signifies a single barcode number for a single product. So, managing inventory becomes much more efficient and unique in nature. In this article, I am going to discuss on how to use barcode scanner for inventory in Excel.
Download Practice Workbook
What Is Barcode?
Barcode is a machine-readable code consisting of space and varying widths of parallel lines representing numerals and characters. It can encode product information. Barcode brings accuracy, ease, speed, and inventory control to Business. Companies use Barcode to collect the info at a go. There are different mechanisms to create Barcode, you will be glad to know that you can create and print barcodes using Excel.
What Is Barcode Scanner?
A Barcode Scanner is a handheld or stationary input device. It is used to capture and read the information contained in barcodes. A Barcode Scanner consists of a lens, a light source, and a light sensor for translating optical impulses into electrical signals.
Step by Step Procedure to Use Barcode Scanner for Inventory in Excel
Barcode Scanner can read any printed barcodes as well as decode the data contained within the barcode and transmit the read data to a computing device. I am going to explain the whole procedure to use barcode scanner for inventory in the below section.
- First of all, keep your cursor in a cell where you want to have the barcode. I have kept mine in cell C5.
- Now, scan the barcode printed in the product packet or box with the barcode scanner. It will automatically generate the barcode number in the selected cell as well as the related information regarding inventory. In my case, I have sorted the scanned data related to inventory into SL, Date, Product, Storage Time, and Barcode columns.
- Along with that, scan all the products’ barcodes to have the related inventory information sequentially.
- Sequentially, select all the barcodes including the label (i.e. C4:C16).
- Then, go to the Data tab.
- Next, click on Outline.
- Afterward, pick Subtotal.
A Subtotal wizard will appear in front of the screen.
- Choose Count from the Use function box.
- Check the Replace current subtotals and Summary below data options.
- Finally, press OK to finish the procedure.
Now, we have the actual count of inventory using a barcode scanner. We have the total amount of products as well as the total number of each product.
- Click on the button numbering 1 to have just the Grand Count.
- You can click on the button numbering 2 to have the total Count of each product as well as the Grand Count.
- Alternatively, you can click on 3 button to have the inventory in detail.
Inventory Barcode Scanner Reminder
In this article, I have shown that I have got inventory data like Serial Number, Date, Product Name, Storage Time, etc after scanning. It’s not mandatory that you will get these values all the time after scanning.
Some scanner just returns the barcode. And some manufacturers may create barcodes with limited information which may lead to getting less information. We can’t even have the product name. In that case, we need to identify similar products by checking the barcode. Regardless of the values, you achieve from the barcode scanner the managing procedure will be more or less the same (depends on your storage format)
That’s it for the article. I have tried to explain the procedure on how to use barcode scanner for inventory in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for further information on Excel.
- How to Generate Code 128 Barcode Font for Excel (With Easy Steps)
- How to Use Code 39 Barcode Font for Excel (with Easy Steps)
- How to Print Barcode Labels in Excel (with 4 Easy Steps)
- How to Add Barcode Font in Excel (Installation and Application)
- How to Create Barcode Without Font in Excel (2 Smart Methods)
- How to Generate Barcode Numbers in Excel (with Easy Steps)