Hi,



So this is my first time doing this sort of task on a sheet.

I have 2 sets of columns that have the same titles except one is cities & the other is neighborhoods.

I've had to cut & paste the data from the right into the left side or insert blank rows to insert new neighborhood names in alpha order & then delete the rows on the left where no data was inserted & push the rows up. I was sure it was ONLY pushing up the left side, not the right side.

From the looks of it none of the rows got misplaced on the left side, but I can never know for sure now.

On the right side which is the neighborhood side 2-3 times now the data is in the wrong place.

ABC neighborhood's data was one row below or above the right row.

I didn't make this mistake, there's no way I'd do that twice & all I did was delete empty rows & move them up.

Why Excel is doing this I don't know, but I'm having to redo work & go back to previous versions to try & find where the mistakes were. I've lost tons of time now.

Please help, I can't keep going thru this.

The left side is done, it's only the right side where I'll have to move names around or continue to insert new rows to fit in a name.

To be clear, I am highlighting all the row cells that have data in it if I'm cutting it, if I'm just inserting a blank row, I do it from the far left side of the file as I didn't see a way to ONLY insert a row on the right side. I didn't think Excel was that smart, but I could be wrong.

Thank you & I Hope I explained things clearly.


Michelle

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