I have a pivot table on A1, E1, I1, M1. How do I make this copy all those on the same sheet.
Please Login or Register to view this content.
I have a pivot table on A1, E1, I1, M1. How do I make this copy all those on the same sheet.
Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks, but that still only copied the pivot table in A1 though
If you want to copy them to the same place on another sheet, you need a small change
I've highlighted the few changes I made to AlphaFrog's code.Please Login or Register to view this content.
Last edited by xlnitwit; 10-23-2017 at 09:08 AM.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks. That copies pivot table3 but then an error pops up saying Could Not Copy Pivot Table.
Comment out the line that says
and then run the code again and see what the error message is, and on which line it happens.Please Login or Register to view this content.
Object doesn't support this property or method
highlights:
Please Login or Register to view this content.
On which line? I've run that exact code in 2010 on a sheet with multiple pivot tables, so I am a little surprised.
Does this answer?
Please Login or Register to view this content.
Apologies, that is a typo- it should read
and notPlease Login or Register to view this content.
Please Login or Register to view this content.
Dammmmnnn. That works beautifully. Thanks!!
Now I just have to figure out how to set the date filter automatically and limit my Top 3 results to actually only 3 results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks