Macro
 

Im having problems with the last part of a macro. The macro deletes 4
columns, sorts on column G then subtotals column H on each change in column
G. The final piece is to remove all the rows where the subtotal is zero so
that just the non zero subtotals are left. Does anyone know how to do this?