View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john john is offline
external usenet poster
 
Posts: 11
Default Repeating a sort

I have a list which I update regularly and need it to be kept in a certain
order. But everytime I go to sort it I have to choose all the same options
again (no header, sort by column D, column B, column A).

Is there any way to set all these options so I can just press a button and
it automatically searches using these options? Or better yet an automatic
sorting of rows in realtime?