Thanks Max. Tried that too and it still didn't maintain row integrity.
We'll just have to make do because we have to validate soldier's data for
deployment today and tomorrow. It's a minor nusance but manageable.

I know your advice and Nick's work on other spreadsheets that I have
created, but these were forced on us and they are linked to 4 other
worksheets and 2 workbooks.

Appreciate everyone's assistance!

"Max" wrote:

Did that and it didn't work.

I'm not sure whether you tried selecting all the cols involved,
eg selecting cols A to E (say)
then clicking Data Sort Sort by Col B* Ascending OK
*your "Names" col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---