Quote Originally Posted by John Wilson View Post
PPT Trial_Sorter (2).pptmThe first is easy

The second might be depending on what you mean. If the order in ONLY the last name that's OK otherwise the best way would be to reverse the name e.g. Brooks,Ruby

Bear in mind what I said about it not being very robust but it should be good enough to save a few hours! I think the first slide is already sorted but just mix them up any way you want. The code will sort it out.

This is great!

So for the second, I mean that usually one text box the one with the name and the one that is sorting the boxes out usually has a name for ex:

Ruby spain
ruby books
ruby jewels

Instead of the code sorting by the first letter of the first name it needs to sort by first letter of the last name in the text box.

the order would be after the macro is run:

ruby books
Ruby jewels
ruby Spain


Yes it really does! Thank u so much!

Please let me know if this is doable if not totally fine. Your help was very very much appreciated! Thanks again for everything!