How do I sort an excel spreadsheet based off of subtotals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort my spreadsheet based off of the subtotal information that
I have just created. Is it possible to do this?
 
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" <[email protected]>
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal of adjacent coloumn 4
How do I subtotal specific / random rows from a spreadsheet? 1
subtotal function won't work 1
Subtotal function is greyed-out - can't insert 3
Additonal info into newly created Subtotal row 1
Average of Subtotals in Pivot Table 0
Subtotals and Conditional Formatting 1
nested conditional subtotals 2

Back
Top