Copying subtotals Only

M

mods1

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,
 
S

Stefi

Try this method:
Set only subtotal rows visible!
Edit>Goto>Advanced>Current Area
Edit>Goto>Advanced>Visible cells only
Copy and Paste!

Regards,
Stefi

„mods1†ezt írta:
 
E

Eduardo

Hi,
Highlight the cells to be copy, press F5, Special, visible cells only, copy,
paste
 
Top