Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have file names listed in column A and B like (see below)
A B……col Jim Boot - data.xls John Wood (Record List).xlsx Ali Khan (data).xlsm Dean Wild - system.xls Bob Will.xlsx Jim Boot (actuals).xlsm John Wood.xls Kam Finch.xlsx Ali Khan (Recorded data).xls The special thing about file names listed in column A and B is that the first two words in those are always the first name and last name of the person. I am looking for a macro which should sort both these columns lists alphabatically and also the way that same name should come in same row. so i am looking for the result something like (see below) A B……col Ali Khan (data).xlsm Ali Khan (Recorded data).xls Bob Will.xlsx Dean Wild - system.xls Jim Boot - data.xls Jim Boot (actuals).xlsm John Wood.xls John Wood (Record List).xlsx Kam Finch.xlsx I'll be very thankful if any friend got sultion for this kind of sorting. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting special text and/or graphics | Excel Discussion (Misc queries) | |||
Special Copy, Paste Special macro | Excel Programming | |||
preparing pivot fields for copying and paste special for sorting | Excel Discussion (Misc queries) | |||
Please help with this special macro | Excel Programming | |||
Special macro | Excel Programming |