Automatic Sort

[ferg]

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

 

[VBA Noob]

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 Noo

 

[Dave Peterson]

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.