Sort ascending, make changes, restore previous order

I've got an AutoFilter in a spreadsheet.  I want to sort ascending, mak
some changes to some cells, then restore the previous order.  Can thi
be done easily or will this require some programming??

Thanks in advane!

Matt 

--
BVHi
-----------------------------------------------------------------------
BVHis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=859
View this thread: http://www.excelforum.com/showthread.php?threadid=47508

0
10/11/2005 3:58:19 PM
excel 39879 articles. 2 followers. Follow

1 Replies
453 Views

Similar Articles

[PageSpeed] 44

I'd use a helper column.

Put =row() and drag down.  
Convert it to values (edit|copy, edit|paste special|values)

Do all you want and then sort by this helper column when you want the original
range.

(Then delete that helper column???)

BVHis wrote:
> 
> I've got an AutoFilter in a spreadsheet.  I want to sort ascending, make
> some changes to some cells, then restore the previous order.  Can this
> be done easily or will this require some programming??
> 
> Thanks in advane!
> 
> Matt W
> 
> --
> BVHis
> ------------------------------------------------------------------------
> BVHis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8593
> View this thread: http://www.excelforum.com/showthread.php?threadid=475080

-- 

Dave Peterson
0
petersod (12005)
10/11/2005 4:12:08 PM
Reply:

Similar Artilces: