pivot table macro

I created a pivot table with the filter from Marketers. However, I would like a table for each marketer. I know under options I can use the "show report filter pages" which creates a TAB for each marketer. Is there a way to apply the same concept to the same tab? The only way I can think to do...

I am trying to create the following pivot tables on a single sheet named Pivot. I extract data from another workbook and then run pivot for the exported data. The Highlighted red (below code) line throws 'Unable to set orientation property error'. The Department Level(1) column has varied row...

Using Excel 2007 - Windows 7 I need to adjust my recorded PT macro to capture all rows 1) Pivot Table should be on the same sheet as the Data 2) Data is in Column A thru P. 3) Data range has varying number of rows from month-to-month (300 to approx. 5000) 4) Pivot Table should be on column...

The following macro creates a pivot table and the data is suppose to aggregate by sum not count but it is NOT COOPERATING! Here is the macro which to my understanding tells the pivot table to do a sum of the data. Can anyone propose a corrected code or another string of code to make it do the...

Hello- So I am trying to add a pivot table into a macro to sort my data. I just recorded the macro while setting up the pivot table I needed but now it has an error almost immediately. I changed a few things around hoping that would do it but nope. The red text is where the error is right now...