Subtotal

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

Jimbo

Every month, I need to take a large spreadsheet, generate subtotals and then
produce a report based on the subtotls. Using the Data, Subtotals and
collapsing the data allows me to see on screen exactly what I would like to
put into my seperate report in email/Word format. How can copy this and
paste it without all of the data as well?

Thanks in advance.

Jimbo
 
Hi Jimbo

One way
Ctrl+G (or Edit>Goto), select Special, select Visible cells only, Ctrl+C
(or Copy) then Paste.
 
Back
Top