View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Unsorting after save

Do you have an older version of the file saved somewhere (a backup,
perhaps?). If so, then you could make use of a lookup between the 2
files to retrieve the correct IDs, and then maybe have only a few left
to correct manually.

Hope this helps.

Pete

On Nov 8, 7:37 pm, Angie wrote:
My co-worker sorted the "client #" column, without sorting the rest of the
worksheet; then freaked and saved it. Without having to re-enter all of our
client #s, is there ANY way for me to figure out how to get the client #s out
of their current ascending order and back to the order before the save???

I'm sure that there isn't, but I'm not ready to give up hope just yet.
Thanks for any help you can give!

Angie