vba pivottable

Uploaded is an image of a pivottable with a filter for 10 or more on the count field. How do I expand each of them to a new spreadsheet and name the new spreadsheet with just the first word on the Vendor Name column, and create new pivot table on the new worksheets like the one on the second image?

I am trying to create a pivot table with VBA where I can deselect some options in my report filter. I have been able to create the pivot I just don't know how to deselect. This is going to be an automated process in the end that creates multiple pivot tables with specific data. This is what I...

Hi- I keep getting the error "for without next" on this code: The code essentially exports a number of sheets from a workbook along with the raw (hardcoded data and saves. What I'm trying to do is change the pivot source of each pivot within the sheet. I think I'm not too far away from...

Hey Guys I have a report that I put together monthly. The report contains 38 different pivot tables all of which reference a single separate excel workbook. I would like to write a VBA macro that changes the data source for all 38 Pivot Tables to a new excel workbook and updates each pivot...