Hi, I'd really like some help and to know if this is possible. It is possible to upload barcodes into Excel along with a description of what the barcodes represent i.e the name of a stock item and price it sells at, and then integrate that information into an invoice when I scan a barcode? Is an excel invoice able to pull the information into itself from when I scan a barcode? I hope this make sense. Thanks so much for any input and help.

The barcode is a unique identifier, so you can use some lookup functions such as VLOOKUP to get product's info based on this identifier and return it to the invoice template.

Creating Invoices and intergrating barcodes and information

Haytham Amairah
Silver Contributor
Jan 31, 2018
Hi,

I'll point you to these links, it's similar to what you want:

TBarCode Office - Microsoft® Excel® Barcode Add-In

How to count inventory using only Excel & Barcode scanner

How to Track Inventory in Excel with a Barcode Scanner
- Bio Sculpture
  Copper Contributor
  Feb 01, 2018
  Hi, Thank you for your help but its not quite what we are after.
  
  Basically I need to be able to create invoices using information from a barcode.
  
  Currently, if I just scan a barcode into an invoice template in Excel, just the barcode shows, I need the invoice to show when I scan a barcode, the name of the product, the price of the product and the quantity bought.
  
  So I'm guessing I need to set-up all of this information on a separate excel sheet and have the invoice link to that information so that when I scan a particular barcode that's on that separate sheet, it draws all of the information into the invoice.
  
  Is this possible and how do I link that information?
  
  Many Thanks.
  - Haytham Amairah
    Silver Contributor
    Feb 01, 2018
    The barcode is a unique identifier, so you can use some lookup functions such as VLOOKUP to get product's info based on this identifier and return it to the invoice template.

Forum Discussion

Creating Invoices and intergrating barcodes and information