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