I have one column of unsorted cells.

I want to create a second column with the sorted values from the first
column.

I can easily copy/paste the first column and then manually use the sort
menu command. But I want to do that via a worksheet function so that
when I change the unsorted values in the first column, the sorted
column automatically updates.

Make sense? I need to keep both the unsorted and sorted versions of the
same data.


--
RogerWilco
------------------------------------------------------------------------
RogerWilco's Profile: http://www.excelforum.com/member.php...o&userid=18906
View this thread: http://www.excelforum.com/showthread...hreadid=499625