View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 109
Default Pivot Table Copy Paste

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

Regards
BrianB
=================================================


(Matthew Davis) wrote in message . com...
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