I am trying to create a macro to run a report from a pivot table, but the name of the pivot table changes everything the pivot is created. Is there a VBA code to create a pivot table and name the tab once the pivot is created and a code to reference that tab to run a report?
I think this should be in the VBA/ excel section?
I'm thinking you just want to loop through every sheet and every pivot table and identify the one you want by some aspect of it like it's feilds then if it is the one you want then "do something".
all this assumes there are other pivots in the sheet and that the pivot has no naming convention - otherwise this becomes easy.
Please Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks