Sorting Data
I got data in column A and B like see below. As you can see below I
got file paths listed in both columns.
A B……col
C:\David Terry C:\Dean Smith (MC) - 23
C:\John Owen C:\Michael Ja - 778
C:\Michael Ja C:\Daivd Terry (ds)
C:\Ali Smith C:\John Owen - x23
C:\Karen Seal - (CC)
I need macro which should sort column B list according to column A
list and results should look like as shown below
A B……col
C:\David Terry C:\David Terry (ds)
C:\John Owen C:\John Owen - x23
C:\Michael Ja C:\Michael Ja - 778
C:\Ali Smith
C:\Dean Smith (MC) - 23
C:\Karen Seal - (CC)
Basically I want it to be sorted so same names in file paths should be
in same row
Please can any friend can help me on this
|