I copied all the info from sheet 1 to another sheet, did a lot of work on it and found that when I did the A-Z sort, every column was sorting except Column A (Column B is blank, so I dunno about that) which remained unchanged and out of synch with the rest of the columns.
I also found that when I press CTRL + A it doesn't select column A and B. When I press CTRL A in Column B it selects everything. When I press CTRL + A in Column A, it selects only Column A. I figure this is why the A-Z Sort isn't working correctly. But when I do CTRL + A on the original Sheet I copied from, everything gets selected regardless.
It would save me a ton of work if I could do the A-Z sort and have all the columns match.
Bookmarks