View Single Post
  #2   Report Post  
JMB
 
Posts: n/a
Default

Would it be better to remove the subtotals (Data/Subtotals/Remove All) then
sort/delete data, then re-apply the subototals?



"Rich" wrote:

Hello,
Does anyone know if you can sort a list after it has been subtotalled?
The reason I ask is because I am basically sorting a list based on a criteria
and then deleted all transactions that offset to each other to equal zero. So
if I could sort the list after it was subtotalled all the subtotalled amounts
that equaled zero would be in order and I could delete them all at once,
instead of scanning through the list. Any help would save me a huge amount of
time.

Thanks,