I don't like things too automatic.

If you're running xl2003, you could apply data|filter|autofilter to the range
and use the dropdown to sort by one of those fields.

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.


ferg wrote:

Can i get an area of a worksheet to auto sort highest to lowest when new
amounts have been added in.
I usually do this manually
Thanx ;)

--
ferg
------------------------------------------------------------------------
ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=563135

--

Dave Peterson