Re: [A-1-Computer_Tech] info/advice needed

2013-05-25 Thread Donk
I think most any usb barcode scanner will work. If you put the cursor into a Excell cell, and then scan a barcode, the info from the code should appear in the cell. But... I dunno if you'll be able to get the different results from a single code to appear in separate cells? It might just

Re: [A-1-Computer_Tech] info/advice needed

2013-05-25 Thread xmdp
If all the data gets put into one cell and has to be separated, you can use the spreadsheet's 'Text to Columns' feature to parse out the data into columns. It will take a little practice to determine if selecting 'fixed width' or 'delimited columns' is most suitable but well worth the effort if

Re: [A-1-Computer_Tech] info/advice needed

2013-05-25 Thread Donk
XMDP sounds like an Excel expert. Excel is a pretty amazing program. You probably 'will' be able to get it set up to import your scanned data just the way you want - so I'd say go for it! Donk On 5/25/2013 11:50 AM, xmdp wrote: If all the data gets put into one cell and has to be separated,

[A-1-Computer_Tech] info/advice needed

2013-05-24 Thread james b
ok guys here is my situation, i am working for a company that installs exede, and i have to do a inventory of all my equipment that i have at my house once a week, it all has bar codes and then has the information on it, my question is could, can i get a barcode scanner, scan all this in and

Re: [A-1-Computer_Tech] info/advice needed

2013-05-24 Thread xmdp
This is pretty easy if you know Lookup function in Excel. It's only slightly harder if you don't. Lookup tables are fairly easy to set up and use. I'll make some assumptions on a possible solution to your scan-in and get info-back. Scan the barcode into A1. Elsewhere on the Excel sheet you