View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default How do I sort an excel spreadsheet based off of subtotals?


It sounds theoretically possible to create a custom list using
subtotal information and then sort data using the list as the
sort criteria. It would require VBA code.
You would want to look at the "AddCustomList" and "Sort" methods.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"Amber"
wrote in message
I am trying to sort my spreadsheet based off of the subtotal information that
I have just created. Is it possible to do this?