'Trick' to restore original sort order after data modified?

L

L Welker

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?
 
C

CLR

If your original data had been sorted, and you knew the conditions of the
sort, you could just repeat them.........but personally, I always do what you
do as soon as I get a new database to fool with.....just add a column and
sequentially number it so I can return to the original sort at any
time.........a macro might help if you do it a lot.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Original Sort/Data Entry Order 18
how do i remove sort and see the original order of the data? 2
Defining Sort Order in Excel Template 1
How to change the column order in Excel table with multiple sort 1
How to sort names in alphabetical ascending order? 7
unsorting a gridview (original order) 1
How can I save a sort order for re-use instead of having to type i 1
Row height adjustment after sort 2

Top