Hi I have this macro a part of a bigger step by step macro.
It make error. It have top sort ascending in column D after numbers.
But it include the text after.
This is the way i can export the file. And also the customername after the number is important to still have when it sort.
But the sort in this column D shall only depend of the numbers not the text after.
Can the code be changed so it only sort after the numbers? But still include the text in same column after the sort.?
The name can be long i have changed it here to not public confidental info.
Please have a look in the sample file.
There is a button in Sheet1 and when you press it shall sort in sheet2 column D
Code in the file is:
Thanks in advance
Abjac
Bookmarks