All,
Stuck again!!!
I've got a range B3:B267, where previous sheets calculations will place names combined with numbers enclosed in brackets....the brackets are always at the beginning of the cell and there are no repeated numbers.
I have managed to work some code (triggered by the button which will send these calculated values to text and remove the blanks), but I cant seem to get the sort right in column D. What I want to happen is for the values in brackets to go to top of the sort.....and sorted numerically and then the remainder sorted alphabetically. I attach a demo file for you to have a look at.
Thanks for looking.
Skyping
Bookmarks