![]() |
#1
|
|||
|
|||
![]()
Hi,
I have a excel-file with rows of unsorted page-numbers from a book. After I select a couple of rows I would like to sort them. Problem is: there are page-ranges like "14f" or "17ff" or "1141-1432". The excel build-in function cannot do this. I would think this requires VBA, but I cant do it myself. I have attached two screenshots: first is the unsorted input, second is the desired output. I have attached a excel-file, too. Desired output is in Worksheet 2. Please note, that the output should be in fact in worksheet 1 (i.e. output should replace the unsorted input), not in worksheet 2. Thank you very much in advance for your help! |
Tags |
excel vba macro sorting |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AustinBrister | Word VBA | 19 | 08-22-2016 05:18 PM |
Sorting Numbers in a Document | rsrasc | Word VBA | 3 | 01-04-2016 11:47 PM |
Sorting Index According to Page Numbers | mohsen.amiri | Word | 14 | 06-25-2015 09:50 PM |
![]() |
CommDude | Excel | 1 | 01-02-2011 04:38 PM |