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.
Thanks for your help in advance.
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.
| Region | Rep | Item | Units | Sum of Total ->pivot headers |
Thanks for your help in advance.