Automatic Sort
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 |
Automatic Sort
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 |
Automatic Sort
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 |
All times are GMT +1. The time now is 04:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com