Jane has attended:
Excel Advanced course
Pivot Tables
Can you copy and paste certain sections of a created pivot table to another work sheet?
RE: Pivot Tables
Hi Jane
Thanks for the post - and sorry i have not got back to you sooner
there are two ways to paste section to other spreadsheets first you could do a standard copy and paste on the selected data in the pivot table
secondly you can double the data area of the pivot table and youm will get specific data on another sheet, the data may vary so try this a few times and see how you get on
If you need any further help just reply to this post
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn