record sheet row order, then restore to that point

C

cate

There is the ability to undo a sort so I suspect the information I
want is somewhere. Is there a way to take a "snap shot" of a sheet's
current row order, and then restore that row order at any point in the
future? During sheet processing, rows will not be added, but data in
any cell may change.

The only other way I can think of doing this, is to record the order
of some "signature" column and then use it to re-write the processed
sheet to a scratch sheet.

Thank you
 
J

joel

Add a new column before you do the 1st sort with number 1 to last row.
then sor tby the new column when you want to restore the data. You ca
use the =ROW() function and copy down the column as a quick method o
getting the numbers in the new column. Then use PasteSpecial - Value
to convert the formula to numbers before you sort.
 

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

Merging from an Excel file with graphics 1
Duplicate Mail Merge Record Every Time 5
Find the correct sheet then find a value on that sheet 8
Searching for specific name on main sheet then copying row data associated with name 7
Cell values to an array, then array transpose to another workbook 8
Using lookup functions for Order Sheet 1
Array with many cells from a row but not in order or together 11
switch to another worksheet, then return to original sheet 2

Top