I receive a pivot table every hour that has 12 columns, which at the bottom has the built in Grand Total function. What I would like to do is copy that Grand Total line (which would have 12 cells) and paste it into another workbook. The problem is the pivot table keeps getting bigger as each hour goes by because it creates another new row every hour.
Does anyone know if that's possible with a macro?
Last edited by Wheelie686; 12-19-2012 at 12:51 AM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks