but i want the columns  sorted and the sorted marks should be put in a
different column. in the "sorted names" column, the name
corresponding to the max. marks goes first...etc. the final thing
should look like this.

name marks sorted marks sorted names
abc 10 89 xyz
def 12 78 jkl
ghi 25 25 ghi
jkl 78 23 mno
mno 23 19 pqr
pqr 19 12 def
xyz 89 10 abc

what would be the vba  code for this one. please help