software

I have a list of names with corresponding numbers (sales data) and I am
wondering if there is a way that when I change the numbers, the list
sorts automatically and updates itself and ranks from highest to
lowest. I know how to do it manually but is there a way to sort
automatically?

TIA.--
sabunabu
------------------------------------------------------------------------
sabunabu's Profile: www.excelforum.com/member.php...oamp;userid=29395
View this thread: www.excelforum.com/showthread...hreadid=497921
So is this not possible?--
sabunabu
------------------------------------------------------------------------
sabunabu's Profile: www.excelforum.com/member.php...oamp;userid=29395
View this thread: www.excelforum.com/showthread...hreadid=497921
sabunabu Wrote:
gt; I have a list of names with corresponding numbers (sales data) and I am
gt; wondering if there is a way that when I change the numbers, the list
gt; sorts automatically and updates itself and ranks from highest to
gt; lowest. I know how to do it manually but is there a way to sort
gt; automatically?
gt;
gt; TIA.

I haven't figured this out either. I did make a small button in a
picture editing program, typed a label on it (sort). I created a macro
that would sort the data, inserted the button I made, then assigned the
macro to it. I just click the button and everything sorts.JF--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: www.excelforum.com/member.php...oamp;userid=24735
View this thread: www.excelforum.com/showthread...hreadid=497921
Thanks. That does help.

How did you assing the macro though?--
sabunabu
------------------------------------------------------------------------
sabunabu's Profile: www.excelforum.com/member.php...oamp;userid=29395
View this thread: www.excelforum.com/showthread...hreadid=497921
sabunabu Wrote:
gt; Thanks. That does help.
gt;
gt; How did you assing the macro though?

I first created the macro. On your worksheet, select the cell you want
your button to appear. Click on insert, picture, from file, select the
button image. Once your button is there, *RIGHT* mouse click on the
button, select quot;Assign Macroquot;.

JF--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: www.excelforum.com/member.php...oamp;userid=24735
View this thread: www.excelforum.com/showthread...hreadid=497921Sorting automatically when I'm doing data entry would drive me nuts. If I
mistype something, I may not be able to find it!

How about an alternative:
contextures.com/xlSort02.html
From Debra Dalgleish's site.

sabunabu wrote:
gt;
gt; I have a list of names with corresponding numbers (sales data) and I am
gt; wondering if there is a way that when I change the numbers, the list
gt; sorts automatically and updates itself and ranks from highest to
gt; lowest. I know how to do it manually but is there a way to sort
gt; automatically?
gt;
gt; TIA.
gt;
gt; --
gt; sabunabu
gt; ------------------------------------------------------------------------
gt; sabunabu's Profile: www.excelforum.com/member.php...oamp;userid=29395
gt; View this thread: www.excelforum.com/showthread...hreadid=497921

--

Dave Peterson