Sorting titles of movies

The easiest way I can think of is to use a helper column where you write the titles as you intend to sort them, ie:
2 Guns --> Two Guns
16 Blocks --> Sixteen Blocks
8 Miles --> Eight Miles
Star Trek 1 --> Star Trek 01
Any VBA solution should indentify the numbers, and then replace by the correspondent words/letters or adding 0(s)... too much work since there can be movies that have a year (4 numbers) on their title, or even 5 (ie: 10.000 B.C.).
As I said, copy the name column to the helper column, then filter the ones with numbers, and re-write them correctly according to your needs... You only have to do it once, and also for every new title you add afterwards.

Originally Posted by Crasher151178

I did it like you said but by changing the numbers in words (1 --> one) didn't do the trick so I tried it with adding zero's and that worked just fine.

If you wanted titles starting with a number to be sorted in their corresponded place (that is, 8 Miles in the E) then that was the way... if you want titles starting with numbers stay the first, then yes, don't replace numbers and fulfill with 0's on the left, as many 0's to equal the longer number length.

Is there a way to autocopy the newly typed title from the colum with title to the help column where I have to change the digit's....

Why not use Ctrl+C and Ctrl+V? The solution you want can be made with a sheet event, but it requires to save the book as an .xlsm, that is, macro enabled. But honestly, if you are not very sure about VBA, don't mess with it for such a thing... It only would be worthy if you were adding a lot of titles everyday, and the time saving wouldn't be that great anyway: you can add all the titles first, and then just make one copy-paste of all at the same time...