We currently have a document that is in no specific order and would like to be able to save it's current state. We wish to sort it by a certain criteria, and then afterwards, revert it back to the previous non-specific ordered state. Is there anyway of accomplishing this?
You could create a copy of the worksheet. R-click the tab < select move or copy < check box for create a copy < select where you want it placed < rename it. Then you can sort it without damaging your original data. Keep it? Discard it? Your original is safe.
Last edited by Russell Dawson; 05-10-2012 at 11:39 AM. Reason: Clarity
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Well the whole point is to organize it so we can edit some of the data in it. If I just create a copy, none of the data would get changed. We have to edit it, and then return it to a customer and would like to leave it in it's original order.
You didn't mention editing in your question
Have you tried converting it to a Table? You can sort it from any field, and still enter data.
add another column ,number down 1 to end
you can then always sort by this column to put back in original order
this is providing you sort the whole thing at the same time
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That sounds like a good idea. Thanks Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks