Question on Printing Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
use a macro for specialcells(xlvisible)
or
use f5 goto special>visible cells only
 
Back
Top