Automatic Sort

[ferg]

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

[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 Noob

[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.


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