Hi all,
Need your help on the topic -copy entire pivot data and paste as values using VBA. Tried out macro recording as well but it shows code of usual copy-paste in VBA. Also 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.
pivot headers are shown below:
Need your help on the topic -copy entire pivot data and paste as values using VBA. Tried out macro recording as well but it shows code of usual copy-paste in VBA. Also 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.
pivot headers are shown below:
Region | Rep | Item | Units | Sum of Total |