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: http://www.excelforum.com/member.php...o&userid=29395
View this thread: http://www.excelforum.com/showthread...hreadid=497921