Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Bar coding and automation FAQ

Scanning into Excel

Scan barcode Part# and Qty in two or more columns in Excel by DougP
Posted: 25 Jul 06 (Edited 19 Sep 07)

Open Excel
1. create your column headings in Row A
Example Part#, Qty, ,   etc
2. Click ôToolsö menu then ôOptionsö menu
3. Click "Edit" TAB and then in the ôMove after Enter Direction" click the ôRightö Option

Following  this next step closely is crucial.
4.    Highlight a series of cells with the mouse that you want to capture data in. And leave them highlighted. We are just using two columns to capture Part number and Quantity.

5.    Notice we started highlighting the cells just below Part# and Qty this is so you wonÆt delete those words. The process starts in the first highlighted cell.

6.    What happens when you either start typing or scanning the first cell A2 gets the data. When you hit the Enter key the next cell to receive data is B2 (it moves right instead of down) then it moves down to A3 then over to B3, down to A4 over to B4 and so on. So it goes over then down a row over then down a row.

Good luck

Back to Bar coding and automation FAQ Index
Back to Bar coding and automation Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close