Thanks for the help. I'll try those things and hope that it works!

"Spiky" wrote:

On Jun 6, 1:15 pm, newbie wrote:
yes, tried highlighting myself and then sorting it, but still... maybe one or
two move. I can't seem to think how I could be doing it wrong? Is it just
not possible to move a whole row by one criteria?


It's hard to know without seeing it. It should work, I do this all the
time. And on data that is not even structured like a block of data at
all. I do it to get rid of blank rows in long printouts I've copied
into Excel. It always maintains the rows properly for me. Perhaps you
could check for hidden rows, or filtered rows if you are in
Autofilter. Or maybe some of your cells are actually formulas, and are
recalculating in strange ways after the sort. I can't think of any
other logical reason this would fail.

One thing that often works for odd problems is to copy the data into a
brand new file. Then try the command again.