Try this method:
Set only subtotal rows visible!
EditGotoAdvancedCurrent Area
EditGotoAdvancedVisible cells only
Copy and Paste!

Regards,
Stefi

€žmods1€� ezt Ã*rta:

Hi I have a huge tax spreadsheet I subtotal by county, the only problem is
when I try to copy only the visible cells, I get everything... Short of
deleting all the lines in between is there an easiser way??
Thanks,