Forum Discussion
Solved
Creating Invoices and intergrating barcodes and information
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.
Hi,
I'll point you to these links, it's similar to what you want:
TBarCode Office - Microsoft® Excel® Barcode Add-In
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.
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.
