It's been a few years since I've used excel, so I'm a little crusty. What he have is an excel file with a list of items and quantities and a second excel file with a list of barcodes and locations. What we need to do is merge those two files into one, so we have the items, barcodes, quantities, and locations.

The catch is, they are arranged in a different order. So I will need to somehow make an association between the bardcode and item name, then make it sort the two new columns of information to match up with their respective item names and locations.