A difficult sort

is this what you need

Sorting1.xlsm

Thanks to both of you, you've given me many good tips. WHER seems to be closest to what I need though, at this point. To further my problem... You have "Hard-coded" the column "A" listing and the listing in column "C". These change daily and might be W12X336, W14X99, etc... the list in column "C" is weights available while the "W40" is a width size. If these change from day to day, how could I use your code to be more "generic" in that regard? Also the list in column "A" could be from 4 to 30 lines. Column "B" will alsways be static. Column "C" could be from 1 to 20 lines.
I'm going to start working with what I have from now and see what I can do with it.

Thanks again,

Doug

Attachment in post 3 replaced, to reflect your comments above.

Try the attached.

This code is capable to handle the records that doesn't match to the list.
(list those to the last)

Please Login or Register  to view this content.

JINDON !!! Absolutely GREAT. Thanks. Not being a trained programmer, I stumble with quite a few of these tasks. But with the great help I get here, you guys/gals make a great difference. Thanks again, I'm just waiting for the chance to get to help someone else (maybe one of these days...).


HMMM..Can't find the "SOLVED" option.

You are welcome.

jindon,

I have run into a problem, and since this was your code, I figured you would be the best help. (Any help from anyone else is always appreciated.)

I have attached another workbook with a simple list and the trouble described.

Thanks,
Doug

I din't understand your intention of changing the code as such....

It is obvious to get the error since you haven't got all the sheets listed.

Ok, I was trying to conserve space by sending an abbreviated workbook. Attached is the workbook I'm developing. It has sheets that have been loaded and is now at the point of sorting the sheets and putting them in the sorted order.
When you open the workbook, you will be put into a select mode, just click "cancel" and then you can see what I'm running into.

I was running the sort routine manually until I get everything worked out.

The "Lists" is the original. I used the "Lists1" sheet because the info on the "Lists" sheet is not located the same as the other.

Thanks,

Doug

OK, since your data layouts are slightly different, try change to

Please Login or Register  to view this content.

Once again, many thanks. That works great!

Doug