how do i trace back my sort command on a column ?????

[rp]

i had Example: student names ,parent names ,room #s .,if i sort only student
names and accidentally save the excel sheet before shutting down the computer
@ the ed of the day how can i undo sort the next day to unsort ,since the
column is not corresponding with the parent's columns now ??please help
asap,t o track back and save as before.

 

[Tushar Mehta]

i had Example: student names ,parent names ,room #s .,if i sort only student
names and accidentally save the excel sheet before shutting down the computer
@ the ed of the day how can i undo sort the next day to unsort ,since the
column is not corresponding with the parent's columns now ??please help
asap,t o track back and save as before.

XL doesn't support the ability to undo something across a file save let
alone a computer shutdown.

Maybe you have a backup from before the incorrect sort?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions