ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotal (https://www.excelbanter.com/excel-discussion-misc-queries/63893-subtotal.html)

Jimbo

Subtotal
 
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



Roger Govier

Subtotal
 
Hi Jimbo

One way
Ctrl+G (or EditGoto), select Special, select Visible cells only, Ctrl+C
(or Copy) then Paste.

--
Regards

Roger Govier


"Jimbo" wrote in message
...
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




Jimbo

Subtotal
 
Fantastic, Roger.
Thanks.
Jimbo



All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com