Question on Printing Subtotals

P

PA

Probably answered dozens of times, and I did a Google search with no success.
I have subtotals calculated in three fields, Puchase Price, Paid, and Balance.
I hide the details to Copy - Paste only the calculated subtotals to another
workbook, but all the details are pasted as well.
Is there a way to suppress Pasting the details. I could obviousy accomplish
this with a Pivot Table, but management prefers the display provided by
Subtotals.

Many thanks.
 
D

Don Guillett

use a macro for specialcells(xlvisible)
or
use f5 goto special>visible cells only
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress a section if the subtotals equals zero 1
How do I sort pivot table data by subtotals? 2
Using subtotals in Pivot table formulas 0
Subtotals and copy and Paste 2
Subtotal Results question 2
Presenting Subtotals only 2
Paste Subtotal's only into new sheet 6
pivot table - hide details but show subtotal for calculated field 1

Top