Subtotals

[dinadvani via OfficeKB.com]

Hi there,

I have a sheet which has some subtotals in it. Now I want to delete the rows
for which the subtotal count is 1

Please help

Thanks,
Dinesh

 

[Light]

Hi, I found a link to this site on a different post. you'll have to change
"ron" to 1 and your row name but it works fantastically for me.

http://www.rondebruin.nl/delete.htm