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

You could record a simple macro.

Then replace your range in VB Editor (Alt F11)

e.g Range("A1:H23") with the text Range("A1").CurrentRegion.Select.

then add a macro button (See link)

http://www.mrexcel.com/tip068.shtml

VBA Noob


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

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