Is there perhaps a hidden column between the two? If the columns are adjacent, Excel generally assumes they should be sorted together. But if there is a column separating them, they will be sorted separately.

As a rule, attaching the sheet is much easier and illustrates the issue much better than trying to explain it without such an example.

Hi,

I would attach a sheet, but it's private information for my client.

No, there was no extra column & the SAME thing happened when I decided to be smart & move those columns over to a new worksheet.

All I did was copy them, then delete them just in case & sure enough, Excel realigned the rows so the ones that were already done were moved down one row <sigh>.

Just terrible. I've probably lost 3 hours of paid work b/c I can't charge my client even though I have no idea what is going on.

Thank gawd the very first file I had had the data in it so I could make sure if I copied it from 2-3 rows down the data was correct. I had cut these from one of the sheets & inserted it into a list of cities.

I can't even trust Excel anymore. I don't know what the problem is, but I'm not happy.

Thanks


Michelle