Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort an excel spreadsheet based off of subtotals?
I am trying to sort my spreadsheet based off of the subtotal information that
I have just created. Is it possible to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort an excel spreadsheet based off of subtotals?
Did you use Data|Subtotals to get the subtotals?
If you did, then you could use the outlining symbols on the left hand side to hide the details. After you do that, try sorting your data. You should see it change order--and when you show the details, you'll see that it really works. Amber wrote: I am trying to sort my spreadsheet based off of the subtotal information that I have just created. Is it possible to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort subtotals? | Excel Discussion (Misc queries) | |||
How to sort data with rows that have subtotals | Excel Discussion (Misc queries) | |||
Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
Excel should let you sort by subtotals | Excel Worksheet Functions | |||
PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) |