can i use sort option when i used subtotal
 

can i use sort option when i used subtotal

can i use sort option when i used subtotal
 

No you can not use sort with subtotals in place. You would need to remove the
subtotals, sort and then replace the subtotals. The re-sorting may mess up
your ability to subtotal though. Have you considered a pivot table. it give
you the same ability to subtotal and allows for a bunch of options including
sorting the data after the fact.
--
HTH...

Jim Thomlinson


"vj bansal" wrote:

can i use sort option when i used subtotal