View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default sort ascending error

The really bad news - unless you have another copy of this somewhere, you're
probably in for a long correction session. If you closed the workbook, then
you cannot undo the sort. If it is still open and you haven't done anything
much with it since the sort error, then you could Undo changes back to the
pre-sort boo-boo.

"blefevre" wrote:

I am on a spreadsheet using 7 rows. I am inputting with the last name of
client in row B. I hit sort ascending in row B and it alphabetized the row.
Then shutdown. Woke up at 3 am to relieze this has only alphabetized this
row and now throws off the data. Example it should look like Smith, Harry
12/4 auto and after ascending it looks like ALba, Harry 12/4 auto. Do I have
to go in and manually change all the last names(row b)? PLEASE someone tell
me there is another way. I have a data base with 1,500 clients that I have
done this to. HELP PLEASE!!!!!!