Hi,
I have to copy and paste the last column of the pivot table to the next empty column. Here is the code for that I have used. The problem is I have multiple pivot table in the same sheet, and I would like to copy the last column of each pivot table into the next empty column. The no.of columns in each pivot table vary but the no.of rows are fixed. Kindly look into the attached file. vba.jpg
Please Login or Register  to view this content.
The code works for the first pivot table but not for the second. Please help.
Thanks,
GK