Microsoft Excel - Creating Inventory with Barcodes

Asked By Sierra Ziegler on 16-Dec-08 05:57 PM
I have a little Cuecat barcode scanner and want to start an inventory of items. It takes awhile to use the ctrl+f, scan the barcode which searches column a, and then enter a number one higher than what is in my quantity column, column f. Is there away to tell excel to do this, to search for the barcode already in the spreadsheet, if it finds one, just add one to the corresponding cell in column f? And if it doesn't find a barcode, just add it at the bottom of the list and then add one in colum f?

Re :: Creating Inventory with Barcodes - SP replied to Sierra Ziegler on 16-Dec-08 11:00 PM

Generate and Print Barcodes in Microsoft Excel

Barcode Software for Excel

The process is identical to Microsoft Word!

Choose Insert Object from the menu and select TBarCode (ActiveX® Control element). A bar code appears instantly in your Microsoft Excel worksheet.

Without a single line of program code you print bar codes with your own data! TBarCode supports data binding of the bar code control to a specific cell in your work sheet. Additionally you can input all characters to be encoded into TBarCode directly.

Hope this helps

Re :: Creating Inventory with Barcodes - SP replied to Sierra Ziegler on 16-Dec-08 11:03 PM

READ THIS - C_A P replied to Sierra Ziegler on 17-Dec-08 07:20 AM
How to add a barcode to a Excel sheetA short description of how to add a barcode to your Excel sheet and link it with a cell: First launch Excel and create a new sheet or open an already existing sheet. Now go to the menu "Insert" and select "Object..." from that item list:

A dialog box appears:

Select "ActiveBarcode" now and click "Ok". Now a barcode will be created inside your document. This will be a standard barcode of EAN-128 type. This is the default type. You can change this to any barcode type supported by ActiveBarcode: Codabar, Code 25 Industrial, Code 25 Interleaved, Code 39, Code 39 Extended, Code 93, Code 93 Extended, Code 128, Data Matrix, DUN-14, EAN-2, EAN-5, EAN-8, EAN-13, EAN-14, EAN-18, EAN-99, EAN 128, EAN-Velocity, GS1-128, Identcode, ISBN-10, ISBN-13, ISBN-13 Dual, Bookland, ISSN, ISMN, ITF-14, JAN, Leitcode, MSI, NVE, PDF417, PostNet, PZN, Royal Mail SCC-14, SSCC-18, UCC-128, UPC-A and UPC-E

Next switch to the "design mode" of Excel (e.g. use this button: ). Now you can modify this barcode. You can change the type, text, colors etc. For this click inside the barcode with the right mouse button. A pop up menu will open:

Select "ActiveBarcode-Object" and then "Properties...". The property dialog of ActiveBarcode will open. Here you can modify the barcode as you like.

Alternatively you can use the property dialog of von Excel. For this use the following button names "Properties" in your symbol bar "Control-Toolbox":

Create a link between a cell and the barcode: Open the property dialog of Excel as described above. Now activate the barcode object by clicking onto it once. The property dialog will now display all the properties of the barcode object. Have a look for the property named "LinkedCell". This allows a link between a cell and the barcode:

Enter the cell's name for the link into this property. That's it!

Don't want actual barcode image - Sierra Ziegler replied to C_A P on 18-Dec-08 12:15 PM
I don't want to have the barcode image in excel. When I scan the barcode, the only thing that comes up is the barcode number. I want excel to search for that barcode number in column a and then put a quantity somewhere else or bold the barcode number so I know I have that in stock, it doesn't matter to me if I know the quantity or not, just that I have it in inventory.