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