| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
record sheet row order, then restore to that point
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 can use the =ROW() function and copy down the column as a quick method of getting the numbers in the new column. Then use PasteSpecial - Values to convert the formula to numbers before you sort. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=185348 Excel Live Chat |
| 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) | |||
![joel[_756_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
