Hi p45cal,

Thanks for your help. The code looks fine but facing some issues in it. If you can add little more description it would be helpful.

Also, please consider the below points to be included in the help:

1) Grand totals should not be included during copy paste.
2)I have a pivot table in range from (A: E). I need to Copy and paste the entire pivot in column I to M. Once this step is done - Based on last filled row, again paste the same pivot below with opposite sign for values of Total column(if the total values are negative then paste as positive) and ignore "Units" column in column L.

Thanks for your help in advance.