View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Automatic Data Sort?

Is there a way to automatically sort a series of data?

For instance, cells A1:A144 have a numeric value. In Column B1:B144, I'd
like to sort those numeric values in ascending order. If I update one of the
numeric values in A1:A144, is there a way that B1:B144 will automatically
update and sort without me having to put a manual ascending sort order to it?

Thanks!