• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy and paste entire pivot data using VBA?

Hi all,

Need your help on the topic -copy entire pivot data and paste as values using VBA. I am a new learner in VBA and also worked on the coding part and finally tried out macro recording as well but it shows code of the usual copy-paste method in VBA. Attached the dummy data for your reference.

Help Required:

I have a pivot table in the range from (A: E). I need to Copy and paste the entire pivot in column I to M and again paste the same pivot below with opposite sign for values of the Total column and ignore the "Units" column in column L.
 
Hi all,

Need your help on the topic -copy entire pivot data and paste as values using VBA. I am a new learner in VBA and also worked on the coding part and finally tried out macro omegle xender recording as well but it shows code of the usual copy-paste method in VBA. Attached the dummy data for your reference.

Help Required:

I have a pivot table in the range from (A: E). I need to Copy and paste the entire pivot in column I to M and again paste the same pivot below with opposite sign for values of the Total column and ignore the "Units" column in column L.
thank you my issue has been solved
 
B

benmartin9920

Guest
Hi all,

Need your help on the topic -copy entire pivot data and paste as values using VBA. I am a new learner in VBA and also worked on the coding part and finally tried out macro recording as well but it shows code of the usual copy-paste method in VBA. Attached the dummy data for your reference.

Help Required:

I have a pivot table in the range from (A: E). I need to Copy and paste the entire pivot in column I to M and again paste the same pivot below with opposite sign for values of the Total column and ignore the "Units" column in column L.
To Copy Pivot Table Format Manually without report filters
Manual - No Report Filters
If the pivot table does NOT have any report filters, follow these steps to manually copy and paste the pivot table formatting and values.
In the original pivot table, copy the entire pivot table body
Right-click the cell where you want to paste the values and formatting
Under Paste Options, click Values
Right-click the cell again, and under Paste Options, click Formatting
The values and formatting appear in the new location.

I hope this is helpful!
Ben Martin
 
Top