At my job we receive customer orders they generate in a spreadsheet form that is emailed to us. These orders need to be hand-entered by us in our ordering system.
The difficulty is that these orders come to us in no specific order. Our system has all of our products grouped and in a specific order. The time spent jumping all over our system is wasteful and prone to errors/oversights.
I'm looking for a program or spreadsheet tool that could sort through their orders using the UPC codes to identify each product and rearrange this information to match our systems product order.