Re: [A-1-Computer_Tech] info/advice needed
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 put ALL the info from a code into one cell - and you'll have to copy/paste it into the cells you want (serial number, manufacturer, price, etc). It might require specialized software to automatically separate the data into different fields. I know a librarian who uses a scanner to scan circulation info from books - but she uses a special library program to sort the data. But then... I've never actually used a scanner so I'm mostly just guessing. Donk On 5/24/2013 6:54 PM, james b wrote: 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 put it into a exel doc. and make it easyier to do for me, because i have 12 to 20 units a week and it gets to be a pain to punch it all in. If you have any questions or problems with any aspect of this site, please feel free to contact me directly bi...@optonline.net Please do not post personal issues directly to the group. To unsubscribe from this list, send an email to a-1-computer_tech-unsubscr...@yahoogroups.com Thank you for using A-1 Computer TechYahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/A-1-Computer_Tech/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/A-1-Computer_Tech/join (Yahoo! ID required) * To change settings via email: a-1-computer_tech-dig...@yahoogroups.com a-1-computer_tech-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: a-1-computer_tech-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [A-1-Computer_Tech] info/advice needed
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 you have a lot of data to process. On Sat, May 25, 2013 at 2:22 AM, Donk d.knier...@verizon.net wrote: ** 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 put ALL the info from a code into one cell - and you'll have to copy/paste it into the cells you want (serial number, manufacturer, price, etc). It might require specialized software to automatically separate the data into different fields. I know a librarian who uses a scanner to scan circulation info from books - but she uses a special library program to sort the data. But then... I've never actually used a scanner so I'm mostly just guessing. Donk On 5/24/2013 6:54 PM, james b wrote: 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 put it into a exel doc. and make it easyier to do for me, because i have 12 to 20 units a week and it gets to be a pain to punch it all in. [Non-text portions of this message have been removed] If you have any questions or problems with any aspect of this site, please feel free to contact me directly bi...@optonline.net Please do not post personal issues directly to the group. To unsubscribe from this list, send an email to a-1-computer_tech-unsubscr...@yahoogroups.com Thank you for using A-1 Computer TechYahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/A-1-Computer_Tech/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/A-1-Computer_Tech/join (Yahoo! ID required) * To change settings via email: a-1-computer_tech-dig...@yahoogroups.com a-1-computer_tech-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: a-1-computer_tech-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [A-1-Computer_Tech] info/advice needed
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, 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 you have a lot of data to process. On Sat, May 25, 2013 at 2:22 AM, Donk d.knier...@verizon.net wrote: ** 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 put ALL the info from a code into one cell - and you'll have to copy/paste it into the cells you want (serial number, manufacturer, price, etc). It might require specialized software to automatically separate the data into different fields. I know a librarian who uses a scanner to scan circulation info from books - but she uses a special library program to sort the data. But then... I've never actually used a scanner so I'm mostly just guessing. Donk On 5/24/2013 6:54 PM, james b wrote: 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 put it into a exel doc. and make it easyier to do for me, because i have 12 to 20 units a week and it gets to be a pain to punch it all in. [Non-text portions of this message have been removed] If you have any questions or problems with any aspect of this site, please feel free to contact me directly bi...@optonline.net Please do not post personal issues directly to the group. To unsubscribe from this list, send an email to a-1-computer_tech-unsubscr...@yahoogroups.com Thank you for using A-1 Computer TechYahoo! Groups Links If you have any questions or problems with any aspect of this site, please feel free to contact me directly bi...@optonline.net Please do not post personal issues directly to the group. To unsubscribe from this list, send an email to a-1-computer_tech-unsubscr...@yahoogroups.com Thank you for using A-1 Computer TechYahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/A-1-Computer_Tech/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/A-1-Computer_Tech/join (Yahoo! ID required) * To change settings via email: a-1-computer_tech-dig...@yahoogroups.com a-1-computer_tech-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: a-1-computer_tech-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[A-1-Computer_Tech] info/advice needed
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 put it into a exel doc. and make it easyier to do for me, because i have 12 to 20 units a week and it gets to be a pain to punch it all in. If you have any questions or problems with any aspect of this site, please feel free to contact me directly bi...@optonline.net Please do not post personal issues directly to the group. To unsubscribe from this list, send an email to a-1-computer_tech-unsubscr...@yahoogroups.com Thank you for using A-1 Computer TechYahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/A-1-Computer_Tech/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/A-1-Computer_Tech/join (Yahoo! ID required) * To change settings via email: a-1-computer_tech-dig...@yahoogroups.com a-1-computer_tech-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: a-1-computer_tech-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [A-1-Computer_Tech] info/advice needed
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 have a data base (table if you will) where
all the barcode numbers of the items are listed, lets say column F.
In columns G, H, I, J, K are five items (you can have more if needed) of
info that relate to the barcode in F. (Name, Description, Model,,
whatever...)
In the cells where you want to return that info you can use a VLOOKUP
formula that will look something like this:
=VLOOKUP(A1,$F$1:$K$50,{2,3,4,5,6},0)
Broken down it means:
=VLOOKUP( - calls the VLOOKUP function
A1 is the cell containing the barcode you scanned in
$F$1 is the top left cell of the lookup table containing your data
$k$50 is the bottom right cell of the lookup table containing your data
2,3,4,5,6 represent the second, third, fourth, fifth and sixth colu,mn of
the lookup table
the zero at the end forces a #N/A value to be returned. That will flag you
that no data exists and you will have to either verify the barcode or add
data to your lookup table.
So the formula will take the value in A1 and look for it in column F and
when a match is noted, returns the information in columns G, H, I, J, K.
Is this some what like what you are after?
On Fri, May 24, 2013 at 6:54 PM, james b jjamescbar...@yahoo.com wrote:
**
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 put
it into a exel doc. and make it easyier to do for me, because i have 12 to
20 units a week and it gets to be a pain to punch it all in.
[Non-text portions of this message have been removed]
If you have any questions or problems with any aspect of this site, please feel
free to contact me directly bi...@optonline.net Please do not post personal
issues directly to the group.
To unsubscribe from this list, send an email to
a-1-computer_tech-unsubscr...@yahoogroups.com
Thank you for using A-1 Computer TechYahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/
* Your email settings:
Individual Email | Traditional
* To change settings online go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/join
(Yahoo! ID required)
* To change settings via email:
a-1-computer_tech-dig...@yahoogroups.com
a-1-computer_tech-fullfeatu...@yahoogroups.com
* To unsubscribe from this group, send an email to:
a-1-computer_tech-unsubscr...@yahoogroups.com
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
