View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Permanently-sorted lists?

Hi everyone-

Here's what I'd like to do:

I'm working with a list of names and associated values, i.e.

NAME PROFIT

Vanguard 300,000
Fidelity 200,000
Schwab 100,000

The profit values on the right will be changing on a regular basis - is
there any way I can create a "permanent sort" so that the list will
automatically sort itself by profit when the values change, rather than
having to go do it manually?

Thanks for your help, I really appreciate it-