G
Guest
I am a moderately experienced user of Excel but I am in a new job and learning new things.
Here is what I need to do
We do a physical inventory each month where 26 locations scan the barcodes of their items on to a prepared excell spreadsheet - works well. However, on my end, I need to re-enter al of those barcodes into our billing software - compatible in exporting TO excel but not the other way. At this time I re-enter each 8-digit barcode number by hand, takeas hours, not to mention the human error that occurs. My question: is there a way to get Excel to print a "barcode" that is readable by our scanner in an adjacent cell to the numeric equivalent produced at each location
Would this require an outside software
Any help is appreciated
Here is what I need to do
We do a physical inventory each month where 26 locations scan the barcodes of their items on to a prepared excell spreadsheet - works well. However, on my end, I need to re-enter al of those barcodes into our billing software - compatible in exporting TO excel but not the other way. At this time I re-enter each 8-digit barcode number by hand, takeas hours, not to mention the human error that occurs. My question: is there a way to get Excel to print a "barcode" that is readable by our scanner in an adjacent cell to the numeric equivalent produced at each location
Would this require an outside software
Any help is appreciated