Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
record sheet row order, then restore to that point
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Trick' to restore original sort order after data modified? | Excel Discussion (Misc queries) | |||
Few rows on my excell sheet have shifted down. How can I restore? | Excel Discussion (Misc queries) | |||
restore sheet | Excel Programming | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
how to restore the original data order | Excel Discussion (Misc queries) |