February 15th, 2011 at 07:50am
Under Forum
tweeking excel numbers?
I am trying to compare a price list to the cost I have in my system. The problem is they compare by upc code as the two are not in order, that and there are items in the price sheet not in my cost sheet, and the price list upc is 13 digits eg 2230112949128, where as my cost sheet have only 12 digits, eg 223011294912. Is there a way to tweek the price list to remove the 8(13th digit?)
Basically the lookup program I made uses vlookup from the UPC from cost sheet, comparing against the UPC from the price sheet, if the match is found, it copies the price onto my cost sheet so that I can compare the two prices.
Thanks in advance.
By Barcode Scanner
December 15th, 2010 at 10:00pm
Under Forum
How do I get my PDA to scan bar codes into pocket excel while I’m scanning into another program?
I use a Dell Axim x5 with a scanner attached to scan the bar codes of books in order to find out their prices on the net. I would like to get a listing of each bar code scanned in pocket excel without having to scan each bar code twice.
By Barcode Scanner
December 5th, 2010 at 09:01am
Under Forum
simple inventory softere or add on to excel?
need software or add on for excel to keep track of adapters for work i don’t need it to involve the price i just need to to use a barcode reader a cheep one so the we can quickly track that we removed some from the inventory to keep track that we added some in that is all and it would be nice for it to show actively how menny of that adapters we have in stock
By Barcode Scanner
November 24th, 2010 at 09:51pm
Under Forum
How do I create a basic inventory database in Excel that will print labels?
I need each label to have both letters and numbers within the sku. I want it to be able to fill in the graduated sku list itself, without me having to type SLT0001, SLT0002…etc. Any ideas or easy formulas that you know of? I want to do this in Excel or Word, not an inventory program. Doesn’t have to be extensive just basic. Thank you!
By Barcode Scanner
November 13th, 2010 at 07:30am
Under Forum
What’s the best way to have a scale AND a barcode scanner interact with Microsoft Excel?
I manage a restaurant, and I’ve tried to inventory the liquor on a weekly basis, but have a difficult time keeping up with it because it’s so time consuming. We outsourced an inventory company for a couple of months to handle it for us, but I realized they use the same inventory methods I do, except they’re not on-site all week and have little knowledge of the inner workings of the business. But they bang it out in record time.
I noticed the only difference between their method and mine was they had a laptop connected to a scale and a hand-held bar-code scanner, whereas I use a pen and paper. I’m pretty familiar with office and could probably set up the ground-work for a really solid system for inventory, and possibly expand beyond just liquor, but I don’t know how to interface these products (that I found cheap online) with Excel. Is there software available so I could:
1) Put the bottle on the scale
2) Scan the barcode
3) Move onto the next bottle.
I know this is a lot for one question – I was hoping for an expert.
By Barcode Scanner
June 19th, 2010 at 03:37am
Under Forum
HOW TO USE BARCODESOFT TO CONVERT UPC TO BARCODE IN EXCEL?
Do anyone know how to use Barcodesoft to generate barcode from UPC in excel?
Best answer:
Yes, but the subject is far to complex to discuss fully here. For starters you need to figure out which bar code you should use.
barcodesoft.com/products.aspx shows the list of Barcodesoft products. Each product’s description includes discussion of the font and it uses, an online demo of the font, pricing, and links to instructions about how to integrate the bar codes with MS Word, Excel, Access, Crystal Reports, VB, and VC++.
By Barcode Scanner
October 16th, 2008 at 04:47pm
Under Forum
Sum function in excel with addons.?
At work they use a barcode scanner to input information into Excel. I would like to sum all of the numbers in a certain column into a cell. This is usually easy, right? =Sum(E4:E100), or whatever. My problem is, this excel document has some addins, and code in these “E” cells that grabs its value from the barcode. I can only sum cells that have a barcode scanned in it, because then it shows a number, otherwise its a blank cell, and (my guess is) the code in it messes up the sum function because it shows #VALUE if I try to sum cells passed the ones with a number in them. But this kinda defeats the purpose… Is there a way to make it sum E:4 through last E cell with a number?
Best answer:
Try this event handler. It will sum all numeric values between E4 and the last row in column E containing data. It will ignore non-numeric entries. If you do not wish the sum to appear in F1, change the “F1″ reference to the cell you wish to display the total in.
Copy the code to the clipboard:
Private Sub Worksheet_selectionChange(ByVal Target As Range)
Dim LastRow
LastRow = Range(“E” & Rows.Count).End(xlUp).Row
Range(“F1″).Value = Application.Sum(Range(“E4:E” & LastRow))
End Sub
Select the appropriate worksheet and right click on the sheet tab.
Select ‘View Code’.
Paste the code into the sheet module editing area to the right.
Close the VBE and return to Excel.
Enter data.
By Barcode Scanner
August 3rd, 2008 at 01:12am
Under Forum
How can I change the setting on a hand scanner from automatic “ENTER” to automatic “TAB” in microsoft Excel?
When I scan a barcode with a hand scanner in Excel, it does an automatic “ENTER” and goes down a cell. I’ve used this same scanner and it’s done “TAB” and moved to the right after data has been scanned. I can’t figure out how to switch them back and forth for different tasks.
Please Help!
Best answer:
In Office 2007 it is:
Options > Advanced > “After pressing Enter, move selection” >
Direction: Right
In previous Office suites it might be slightly different.
By Barcode Scanner
July 30th, 2008 at 01:02pm
Under Forum
Where can I get some offline data-entry or typing or Auto Cad drawing or Excel Engg. Cals works that pays me?
Where can I get some offline data-entry or typing or Auto Cad drawing or Excel Engg. Cals works that pays me? I want to work at home at my leisure and as I feel like. I can up-load the same online after completion, as I own my computer and a dial-up connection too. I can try a bit on Adobe’s page making, photo-cs too. I own a Laser color printer and a Canon’s scanner too. I want put them on use and earn a few more chips for my butter to the bread I have. Shall that be paying me honestly for the work that it extracts from me, and without any money in advance from me? The main fact is that I reside in India and the matter should be reachable to India. Most of the site that is advirtised are from USA and after registering or clicking or the same says that this is not for you area!!!
Best answer:
Oh sorry you are all the way there. We are needing AutoCAD help right now where I work.
By Barcode Scanner
March 4th, 2008 at 09:58pm
Under Forum
How to upload scanned barcodes into Microsoft Excel?
I am scanning barcodes from a portable device (SPT 1700) w/ palm software using a serial cable. This serial cable is connected to a laptop. The laptop does not have the HotSync application.
IS THERE A RELIABLE SOURCE I MAY DOWNLOAD HotSync version 4.0???????
To my knowledge, Excel has the option to import data from any file. I have already created the spreadsheet for this project.
This is an inventory project that is currently giving me a headache. Thank you ALL!
Best answer:
You should be able to just scan the barcodes directly into Excel. Mostly every barcode scanner works with Excel. Just click in the cell where you want the numbers to go and scan the barcode.
By Barcode Scanner
Next Posts
Previous Posts
