AlejandroMaximus
New Member
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.
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.