Pivot Table Copy Paste

M

Matthew Davis

Hi guys,

I want to copy/paste some data from a pivot table. However, I only
want to copy certain "headings", certain lines that are not hidden.
When I hit paste, though, all the lines that were hidden show up. I
don't want them pasted. Is there a way to get rid of those?

Thanks in advance!

Joe
 
B

BrianB

I have not tried this, but Edit/Goto/Special Cells/Visible Cells only should work.

Regards
BrianB
=================================================
 
Top