Sort data to match a predefined list order

**Neil0782** · 11-12-2012, 08:17 AM

Hi,

I usually manage to find the answer to all my problems within online forums, but this one seems to not exist!

Basically I have a 4 columned worksheet.

Product Code
Description
Qty
Price

I basically want to sort this data by the Product Code, to match the order of product codes in our Warehouse Catalogue, which unfortunately is not in any particular order..

Any ideas would be greatly appreciated!

**e.isayev** · 11-12-2012, 08:21 AM

Can you attach excel file with desired output and simulation

**arlu1201** · 11-12-2012, 08:21 AM

It will be good if you explain with the help of some excel sample files.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**stephenkeefe** · 11-12-2012, 08:37 AM

If your Warehouse Catalogue is in any electronic format, then
1. copy it into Excel
2. type 1 in the cell to the right of the first row; 2 in the next and then drag/fill down
3. save and use this as vlookup source to a new (5th) column in your worksheet called (something shorter than) "WarehouseCatalogueSortOrder".

**Neil0782** · 11-12-2012, 08:39 AM

Ok, Have attached file.

Column F is the catalogue order which I need to sort the first 4 column by.

Hope this is clearer, I can upload other example if that helps.