Pivot Table Copy Paste

  • Thread starter Thread starter Matthew Davis
  • Start date Start date
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
 
I have not tried this, but Edit/Goto/Special Cells/Visible Cells only should work.

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