Hi all,

I need to know how to do a complex sorting procedure. I have 150 rows of data. In the first column are names, then 11 other columns with all sorts of data in. I need to alphabetise the rows, however

1. The entire row has to move position with the name, (I can't just swap the names around and leave their data behind!)

2. The names are in the form JOHN ANDREW SMITH. I need them alphebetised according to their surnames, ie by S-Smith, not J-John.

Hopefully someone looking knows the answer!

Thanks guys