+ Reply to Thread
Results 1 to 2 of 2

Match Preexisting data with imported data

  1. #1
    Registered User
    Join Date
    06-26-2008
    Location
    Scott AFB
    Posts
    2

    Match Preexisting data with imported data

    I apologize for the awkward wording of the title, but I couldn't really think of a better way to do so.

    Basically, here's the idea of what I need help with. Where I work, we use a barcode scanner to get quantities of equipment. It spits this data out into a raw text file. Now, I know I can import that data into Excel, and make a nice pretty spreadsheet.

    Here's what I want to be able to do, however. I want to make a spreadsheet that has all the equipment items preloaded into it, along with the quantity that we're supposed to have of said equipment. Then, I would like to import the data from the text file, having it match items in the spreadsheet to their equivalent in the imported text file, and then bring in the quantity scanned. That way, I can use some conditional formatting to show when there is a miss match between "Required" and "On-Hand" quantities.

    What I don't know how to do, is get Excel to only import say... the name of the item, and the quantity scanned, instead of all of the information that the scanner spits out. Also, I don't know how to make it match the name, with the one preloaded into the spreadsheet, so that the correct quantities are matched up.

    Here's an example of what the scanner spits out:
    FIELD WIRE,6145-01-155-4256,[Scanned Quantity Goes Here],N/A,N/A,RESPONSE TRAILER,,

    The scanner creates records like this the first time you scan an item. So if you scan Field Wire first, it's the first record. However, if you scan it fourth, it's the fourth record. How do I make that match up with a predesigned spreadsheet?

    I'm sure this is a bit complicated, because it's certainly well over my head. Any forumlas... advice... anything you can think of to help me with this issue would be greatly appreciated. Thanks in advance!
    Last edited by Jonexe; 06-26-2008 at 11:35 AM.

  2. #2
    Registered User
    Join Date
    06-26-2008
    Location
    Scott AFB
    Posts
    2
    Since there doesn't seem to be a button to allow me to edit my post...

    I've also asked this question here:
    http://www.ozgrid.com/forum/showthre...446673#Similar

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1