I think the Filter facility of Excel will do this for you...
Create a dummy spreadsheet - put in half a dozen different names in one column with corresponding different numbers against each name in the next column.
Put a dummy name at the top with a zero against it (don't know why) select the whole block of names and numbers and select Auto Filter from the Data Tab.
All you need do is to click on the down arrow of the column you wish to rearrange - the corresponding columns move in concert with the change on a row by row basis.
Peccavi
May 2009