Sorting Code A to Z Order

[BillySpivy]

Hello,

On the Vehicle Interval Service sheet there is code to sort the table by the mile interval services 5K, 30K, 100K, and 150K Services by clicking on the orange shape. Which it does well but is there a way to also sort the services within those to A to Z order?

I also noticed that "Other Service 10" comes before "Other Service 2". Isn't 10 higher than 2 or does Excel treat digits differently?

Thank you very much for your help

[Joske920]

Hello,

Its sorted alphabetically, that's why 1 comes in front of 2 and then 3 until 9 then excel looks at the number behind 1 what is 0

you could make then 01, 02, 03 ...,09 ,10

then it sorts like you want it to

[BillySpivy]

Thanks good tip I appreciate the help. This should do it.

[Joske920]

Sort the data list and the macro will take this follow that sorting line by line

[BillySpivy]

Can the code have the added sort data list first to take care of that?

[Joske920]

yes it can be added but you might lose the possibility to set services in a particular order outside the alphabet
you only need to set the list with services 1 time and sort it there the way you want it presented

if you add a new service later on it might be in a bad place when the macro puts it in alphabetical order

[BillySpivy]

Okay why I ask is to have code that does exactly what the column sort in the table first just like what I do. Then have the rest of the code to run to take care of the groups.

[jindon]

Replace "Macro1" with below

Please Login or Register  to view this content.

[BillySpivy]

Thank you jindon that works great.