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!
Bookmarks