Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
if you can be more specific regarding the format of your incoming spreadsheets, and what you need as a final result. For instance you receive multiple sheets that need to be consolidated into one? or you only need to be able to sort one big one. Why do you need to re-enter what is already entered? clarifying that make it possible to provide more help – datatoo Jul 14 '12 at 16:22

closed as off topic by random♦ Jul 14 '12 at 2:09

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 0 down vote

If we're talking about relatively simple spreadsheets here (no complicated formatting or weird stuff going on) then just "sort" according to whatever column the UPC numbers are in. Just highlight the column and then sort either ascendingly or descendingly. Do it again with your catalog (if it hasn't been already) and that should line up your two spreadsheets cell for cell.

I would also assume you use Excel so I can't really help with the specifics. I use the free Libre Office app called Calc which is 100% compatible but has very different menu's and different ways to do the same things. (I haven't used XCel in over 10 years since I don't want to pay for it and really don't need to either.)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.