|Please don't take this the wrong way, but we're 11 posts into this thread and we still don't have a clear understanding of your requirements. Since you are the only one that knows exactly what you are trying to to do, you have to be very specific and very detailed in your explanations. History has shown that when we make assumptions based on limited information, we usually end up doing a lot more work than necessary.|
Regarding your latest response "Yes, absolutely. Numerical."...
You've asked us to build a table that is 3 columns wide. As soon as you have a table that is more than one column wide, "numerical" becomes an ambiguous answer.
Technically, we could consider both of these tables to be in "numerical order", yet the output is very different:
A B C
1 1 2 3
2 4 5 6
3 7 8 9
A B C
1 1 4 7
2 2 5 8
3 3 6 9
In addition, you have values that start with 4 digits as well as values that start with 4 digits followed by an "x":
9114 RED OS
9114x RED Plus
We could easily assume that 9114 is numerically before 9114x but, as I said, once we start making assumptions, we may end up doing extra work if that assumption is wrong.
Finally, you have values that begin with the same 4 digits, but the text following the numbers is different:
1377 RED/BLK S
1377 RED/BLK M
1377 RED/BLK L
1377 RED/BLK XL
Once again, we could assume that you want these in numerical and then alphabetical order, but once again we may make the wrong assumption.
It would be really helpful if you could figure out how to use the pre tags and post a short table that shows what your output should look like, making sure that you include every type (not every piece) of data that you have so that we know what you are trying to accomplish.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.