Sorting issue in Excel VBA

[questionguy]

My spreadsheet has two sheets one called Database and the other Cutlist. I use Database to enter information and when I click on Create Cutlist (button) a sorted table is created in Cutlist.
Everything works well, except there is a sorting issue.

It should sort by size (lowest to highest) and length (highest to lowest).

Sorting should look like this…

Size
2x4
2x6
2x8
2x10
2x12

Length
##’-## ##/##”
down to
#/#”

Very simple, but the sorting is off when it comes to numbers greater than 9 for size and digits greater than 1 for length... (See attachment)
Thanks for your help!

[mehmetcik]

Hi

It looks like you are sorting using column F.

This will never do what you want. Because the x in 2x10 makes your data alpha numeric rather than numeric. in which case 2x10 is smaller than 2x4.

Split column F into two columns then sort by the number before x and then by number after x.

Try inserting this routine into your code.

Please Login or Register  to view this content.

[questionguy]

Thanks a lot!