Did you use the Subtotal feature to create the subtotals, or did you
create them manually?

Instead of subtotals, you may find it easier, and more flexible, to use
a Pivot Table to summarize the data. There are instructions in Excel's
Help, and Jon Peltier has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


Katherine wrote:
Hi,

I have just subtotaled an inventory spreadsheet at work and now have 13,000
lines of data. Now that I have the subtotals by inventory item, I want sort
so that I have all the subtotals together as a group, and all the data that
went into the subtotals separated out. But Excel refuses to do this, even
though I have two columns that I would be able to do this by because the
subtotals have nothing in those two columns and the other lines do have data
in those two columns. I am very frustrated, because going through 13,000
lines of data to delete this information by hand will be extremely
time-consuming!!! Please help!!!

Thank you,
Katherine


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html