RE: copy paste entire pivot data Using VBA

[Keerthi@21]

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 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 Total column and ignore "Units" column in column L.

Region

Rep

Item

Units

Sum of Total ->pivot headers

Thanks for your help in advance.