System Light Dark

xentr_theme_editor

xentr_page_setup xentr_appearance xentr_sidebar

  • xentr_page_width

    xentr_toggle_page_width

    xentr_page_width_description

    xentr_color_pickers

    xentr_toggle_color_picker

    xentr_toggle_color_picker_description

    xentr_typography

    xentr_select_the_font_you_want_to_use

    xentr_node_layout

    xentr_grid_layout

    xentr_grid_layout_description

  • Style variation

    xentr_select_the_style_variation_you_want_to_use
    System Light Dark

  • xentr_sidebar

    xentr_toggles_sidebar

    xentr_sidebar_description

    xentr_sticky_sidebar

    xentr_sticky_sidebar_description
    xentr_sidebar_position
    Left
    Right
  • Please do not post any links until you have 3 posts as they will automatically be rejected to prevent SPAM. Many words are also blocked due to being used in SPAM Messages. Thanks!

Barcode Scanner for inventory using exel?

sswilson

sswilson

Moderator
Staff member
Joined
Dec 9, 2006
Messages
27,388
Reaction score
5,351
Location
Moncton NB
xentr_thread_starter
I've never been a corporate MS Office user (outside of Word) so I've never played with Excel in any way shape or form.

I've got a temp job coming up and it sounds like they intend to give me a bar code scanner to do inventory, and expect me to import that info into a spreadsheet. I've done some quick searches and it looks like I can probably just create a new excel spreadsheet and then assign what the barcode scanner picks up to specific fields. Is it really as simple as that?

Thanks in advance.... :)
 
As far as I know they just emulate keystrokes... so click in cell, scan barcode and it should type out the digits/letters.
 
Normally a scanner just acts like a keyboard. If you scanned 5 barcodes, normally it would just list all 5 sequentially with a carriage return between them.

Any sort of organization would have to be done with excel.
 
xentr_thread_starter
Thanks. I'll have to see how this shakes out. They haven't given me any info outside of inventory to be done, they want a spreadsheet, and they'll provide a scanner. :)

I would have expected something like this to be done using whatever software package they use, and being provided with their hardware, but it doesn't sound like that's the case as they want me to bring my own laptop. (Pity I couldn't just scan it into my Kindle Scribe and export a PDF..... ).
 
We use bar codes scanners at my job.

You can configure them the way you want, to insert a character before / after what you scan (like a carriage return), and a lot more.

As the others said, they act as keyboard, but you have some power on it :cool:
 
I have had to work with an ID scanning company in the past and was tasked with speeding up their assembly. Needless to say the scanning software for the was exceptionally complicated. But even some hand held barcode only scanners have complicated software bundles but others brands are just basically glorified USB keyboards. It will really depend on what they provide you.
 
xentr_thread_starter
Izerous said:
I have had to work with an ID scanning company in the past and was tasked with speeding up their assembly. Needless to say the scanning software for the was exceptionally complicated. But even some hand held barcode only scanners have complicated software bundles but others brands are just basically glorified USB keyboards. It will really depend on what they provide you.
Click to expand...

It doesn't sound like there's any kind of software required but I'll cross that bridge when I get there.

I'm headed to the site this morning so we'll see how it works. Apparently it's a bluetooth scanner so hopefully I can just adopt it to my laptop and it'll fill whatever cell I've got selected.
 
sswilson said:
It doesn't sound like there's any kind of software required but I'll cross that bridge when I get there.

I'm headed to the site this morning so we'll see how it works. Apparently it's a bluetooth scanner so hopefully I can just adopt it to my laptop and it'll fill whatever cell I've got selected.
Click to expand...
heyo, let me know the make model of scanner and if it's one I sell, I likely will have resources I can access to help you figure it out if you have any difficulties or frustrations.
 
xentr_thread_starter
Marzipan said:
heyo, let me know the make model of scanner and if it's one I sell, I likely will have resources I can access to help you figure it out if you have any difficulties or frustrations.
Click to expand...

Thanks for the offer, but it's all good. No idea on model, it picked up the hardware as soon as I plugged it in.

Task was as simple as it sounded above, although mind numbing to say the least. :)

Open a blank excel, select the first cell, scan the ser# to fill the cell, hit enter to advance to the next cell, throw the item into the scanned bin and repeat for the next one. Multiply that by 172 items and you're done. :)

Oh, and don't forget to hit enter or it starts to get messy.

edit: If I knew enough about excel, there's probably a setting which would automatically advance to the next cell after getting the bar code info, but that's above my pay grade. :)
 
Last edited:
You must log in or register to reply here.

Latest posts

xentr_legal_notice_title

xentr_legal_notice_description

Back
Top